Using Forms in Ecel Macros

[jjrtootle]

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?

[Mark O'Brien]

So long as your code looks something like this:

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

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

Unload Me

This will kill the form and return you to the next part of your macro.

HTH