Forms

[Guest]

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,

 

[Doug Glancy]

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

 

[Bob Phillips]

Just launch the 2nd userform from the first. The first will stay open, and
you can return to it by closing the second.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)