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...
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...
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
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...
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...
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...
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?
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...
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?
