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.

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