Form that prompts within a macro
Posted on 2007-04-06
I have a VBA macro running off a userform and need to prompt for user input. I used to do it with a msgbox, but I'm trying to make it a bit more sophisticated. I have made a form with "yes" and "no" buttons and a checkbox. At the moment, users click a button on the main form. That used to ask for a prompt like this:
If msgbox("This will make changes without a chance to check each one. Are you sure you want to continue?", vbYesNo, "Change all") = vbYes Then
Now I want it to show a form and wait for their answer: I load the form and show the form... the buttons are available and the variable from the tickbox feedbacks correctly into the main form . And when they press the buttons, the subform hides itself and everything is fine. However, if they choose to terminate the form (as in the close box in the upper right hand corner), the whole program ends, not just the subform. This leads me to believe I have done something very wrong!
How should I link this subform (prompt) to the main form? Where did this go wrong?