Closing forms

[M atthew J. Couture]

I have hit a block, I need to close one user form and invoke another. The
first user form inputs data into a specified cell when you click on
"Continue" what I need is for that form to close and another form to open
right after it when you click on "continue". can anyone assist?

 

[Nigel]

From the first form include the following code attached to the Continue
click event

Private Sub Continue_Click()
Unload Me
UserForm2.Show
End Sub

Cheers
Nigel