Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Crashtestdummy

    Printing Reports

    Hey all, I'm writing an excel worksheet that will allow people to print pro-forma orders. What I am trying to do is that when they enter a stock value in this spreadsheet, and the value is lower than the minimum stock level set, for it to show up on an order. If the value entered is higher...
  2. Crashtestdummy

    Phantom Macro's

    Hey VBA boffins, Here's one for ya. I havea spreadsheet herre at work that contains pricelists and discounts for all our customers. Over the years different people have added and deleted parts. It is at a stage now where when the sheet is opened, it gives the virus warning on macro's. This...
  3. Crashtestdummy

    Minimising a form

    Dear geniuses, I've got a excel spreadsheet that uses a full screen VBA form as its menu's. My question is this. Is there any way of putting the minimize button on the top left corner of the menu screen? Thanks for your help. Crash
  4. Crashtestdummy

    Updating a custom spreadsheet without losing info

    I have written a liitle program in excel using VBA. As people start using it, they are comming up with new suggestions on what to add to the spreadsheet. My problem is this. Can I update the spreadsheet so that the changes will take effect without people having to re-enter all their...
  5. Crashtestdummy

    Keeping formulas in excel fields

    Thank you dsi!! your code has helped alot. many thanks. Just one more question. it puts the formula result in the the field after the the field is changed to 0. Is there a way of it doing that check when the sheet is made active? I tried using the worksheet_activate event but I get...
  6. Crashtestdummy

    Keeping formulas in excel fields

    Hey Excel gods, is there any way of entering a formula in an excel field, so that if a single entry is made it will override the formula, but if the field is then cleared that the original formula returns. For example : if A1 hold the formula "@sum(F3:F9)" but the user will be able...
  7. Crashtestdummy

    how do I get rid of the "full screen mode off" button

    I am writing a excel database with the use of VB. In some of my user screens I use the full screen mode in Excel. Ny question is as follows. Is it possible to get rid of that floating button to turn off full screen mode. I'm only new to VB and there is probably a simple way to do this. I...
  8. Crashtestdummy

    Cant I show a clock to select a time in Excel?

    Is it possible at all when using VB forms to enter data into a excel spreadsheet, to display a clock or similar to select a time instead of typing the time in. I know you can show a calender to select the date, so why not a clock? any suggestions?
  9. Crashtestdummy

    Date format from VB to excel

    I have a data entry from in VB which automatically adds the date to the entry on the excel workbook. When the auto date is shown on the form, it is in the format I want it. It shows it in the same format as it grabs my system date (dd/mm/yy). When I put the entry on my worksheet, it puts it...
  10. Crashtestdummy

    Executing a VB Form on opening an Excel Workbook

    I am able to execute a for from withing an excell workbook, but throught the aid of an "main Menu" type button. I am looking to execute my form as the particular excel file is opened. Anyone have any Idea's?

Part and Inventory Search

Back
Top