Pls help with Excel UserForm
 

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.

Pls help with Excel UserForm
 

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.

TotallyConfused wrote:

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.

--

Dave Peterson