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