If you have Userform 1 and Userform2 each with a Commandbutton:

In Userform1

Private Sub CommandButton1_Click()
'Userform1 code here
Me.Hide
UserForm2.Show
Me.Show
'more Userform1 code here
End Sub

In Userform2

Private Sub CommandButton1_Click()
'Userform2 code here
Unload Me
End Sub

hth,

Doug Glancy



wrote in message
...
How can I go about opening one of my forms then opening
another form which I will later come back to, I would like
to come back to where I left the code in my first form. I
was thinking I should open the 2nd form from my 1st form
and then use a GoTo statement to come back -- but this is
not working. Basically I want one form - the 1st form - to
stay open the whole time. This may sound confusing let me
know if I need to rephrase.

Thank You,