I'm writing a macro in excel that calls a user form. On the form I want to have a button that allows the user to return to the origional macro module and continue executing code from the place where it left off. What codes should I use to exit the form and how do I get the orgional module to "remember" where it was?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using Forms in Ecel Macros
- Thread starter jjrtootle
- Start date
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
So long as your code looks something like this:
<pre>
Public Sub main()
Dim oRange as Range
Set oRange = '....blah blah blah
Userform1.Show 'Your code for showing your userform
' Some more code here
End Sub</pre>
...The code will continue from the line "Some more code here" when you get rid of the userform.
Now, the button on your userform, I'm guessing that you simply want to kill the userform and allow the macro to continue. In the buttons click event in the userform code module simplt put this line of code:
<pre>
Unload Me</pre>
This will kill the form and return you to the next part of your macro.
HTH
<pre>
Public Sub main()
Dim oRange as Range
Set oRange = '....blah blah blah
Userform1.Show 'Your code for showing your userform
' Some more code here
End Sub</pre>
...The code will continue from the line "Some more code here" when you get rid of the userform.
Now, the button on your userform, I'm guessing that you simply want to kill the userform and allow the macro to continue. In the buttons click event in the userform code module simplt put this line of code:
<pre>
Unload Me</pre>
This will kill the form and return you to the next part of your macro.
HTH
Upvote
0
