Closing the Userform when macro is running
Hi,
I've created an add-in that, upon pressing the button, a userform appears and different macro codes execute depending on the user's command-button choice.
After the user presses a command button, the macro springs into action, and will often run for 1min or so. What I would like to do is to have that userform close after the user presses the command button and starts off the macro.
My setup is like this:
Add-in button code:
Sub ShowForm()
Myform.show
End Sub
-----------
This shows the userform. I then have code within each command button.
Thanks for your help in advance!
|