G
Guest
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
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