Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a form. On the form is a "Submit" and "Quit"
button. If the user pushes the "Submit" button, the macro checks to see if any information has been entered. If not, a message is displayed telling them to enter info or use the "Quit" button. If they select the "Quit" button, , the macro clears out some labels and text boxes and closes the form. The intent is when the form is opened the next time, it is populated with new values. The problem, I'm having is that when the user clicks on the "Quit" button, the UserForm_Initialize module is automatically kicked off and populate the labels and text boxes with wrong information. How can I stop the UserForm_Intialize module from being kicked off when the "Quit" button is pushed. Thanks for the help........ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop macro with userform | Excel Discussion (Misc queries) | |||
XL 07 Initializing Folders | Excel Discussion (Misc queries) | |||
Initializing Combobox in a Userform | Excel Programming | |||
Initializing static variables in VBA | Excel Programming | |||
Initializing Userform | Excel Programming |