Pls help with Excel UserForm

T

TotallyConfused

I have a Userform and I would like to know How I can get back to the form
after it closes. The form will open and I will click on buttons this will
take me to the end of the form and then the form closes. After the form
closes the Excel sheet stays but I can't get back to the form. Can someone
please help me with this? Thank yo.
 
D

Dave Peterson

If you're the developer (or can change the workbook), you could create a macro
that shows the form:

Option Explicit
Sub ShowTheUserForm()
userform1.show
End sub

Then run this macro (via alt-f8) or even add a button from the Forms toolbar and
plop it onto a worksheet. Then assign this macro to that button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top