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

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

i like using a multipage form instead of using different userforms.
it keeps all the info available & you only have one userform to have to
work with.
you can hide the different tabs that you don't need initially & then
make them visible & set them in focus when needed.
susan



John Bundy (remove) wrote:
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