I want to be able to navigate between two userforms (seperate)

The first Userform is the chooser it basically has a combobox and when
the user selects from the Combobox the second userform loads, and the
first is unloaded. That seems to work fine. However, if the user has
chosen the wrong selection in the first userform and wants to go back
to the first, it overlaps and doesn't unload the second userform,
However, there are going to be multiple userforms accessed from that
first userform and it won't unload what isn't loaded (as it should be),
and a simple If...Then statement didn't work because I used mismatched
types. Here is kind of what I've got.

Open the workbook and Userform1 shows up.
(User selects entry from Combobox).
Userform2 loads and upon initializing Unloads Userform1.
(User clicks command button to return to Userform1)

Here either two things happen, A)Hell breaks loose, or B) not what I
want it to do.

I tried using

If Userform2.Show Then Unload Userform2 End If

But I know that isn't right because I'm mixing things and because Excel
threw a fit at me. Thanks for any help.


--
RPIJG
------------------------------------------------------------------------
RPIJG's Profile: http://www.excelforum.com/member.php...fo&userid=9285
View this thread: http://www.excelforum.com/showthread...hreadid=480698