I have made a program that has to take userinput from Multipage UserForm and place it into a spreadsheat, the user wont see the spreadsheet, because in the end all the result will appear in a listbox in the Multipage UserForms last page.
My questions:
1. If the user forgets to put information into a txtbox or a combobox, how can I get the program to tell it to the user
2. Two of the txtboxes the user has to put in values, and one of the box1 can't be > then box2.
I have tried to fine some code on this, because I think that I must use a subprosedyre...
I will be very greatful for some assistance!!!
The Rooster;)
VB Excel - userinput -> UserForms
Jan Pickard
At some point, doesn't the user click on a button (or perform a similar action) in order to proceed When processing the click, before actually going to the next part of the program, validate the user entries, and if they are invalid, show a message box and return to the previous state. You can help the user by highlighting the missing/incorrect data.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______