depending on what you need, show and hide will work if you need to switch
back and forth, other than that Unload Userform1
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"rowlo-efc" wrote:

I am trying to create two userforms to populate the same worksheet.

The first one asks for contact details, and then when that is
completed, I want the user to click a next button that opens a new form
asking for company details.

Is there an Unload/load me code that I should use to close the current
form and open the next.

The tricky part is that I want the next form to continue adding data
along the same row. (picking up where the previous form left off...)

Regards

J