In userform1 have the code

UserForm1.Hide
UserForm2.Show
Userform1.Show

in Userform2

Unload Me

Otherwise you lock up userform2 in a deathloop such as you have deserved.

--
Regards,
Tom Ogilvy


"Dan Perkins" wrote:

I have created a series of forms.
Example: UserForm1 and UserForm2
In UserForm1 I have a Command Button that has the code
UserForm1.Hide
UserForm2.Show

In UserForm2, I have a Command Button to exit. The idea is to hide Userform2
and show Userform1. The code is
UserForm2.Hide
UserForm1.Show

When 1 click the command button on UserForm1, it is no longer visible and
UserForm2 is visible. The problem is when I click the exit command button in
UserForm2. The result of this is that UserForm1 is show, but UserForm2 is not
hidden. I cannot access it or click on any controls, but it is still visible.

I have also tried to unload UserForm2, and that does not succeed.

I am using Excel 2003 (11.8003.8036) SP2 (Microsoft Office Professional)

Any help would be appreciated.

Thanks

Dan Perkins