Userform Error

[gugumnd]

I have a problem manipulating user forms im my program. I have 3 userforms (Form1, Form2, Form3). Form1 is the main page. Form2 is shown by clicking a Commandbutton1 in Form1 and Form3 is shown by clicking a Commandbutton2 in Form2. I want to go back to the main page (Form1) if lick a Commandbutton3 in Form3 but I get an error "Form Already Displayed; Can't Show Modally Error" when clicking button 3. See codes below. Thanks in advance for any help.


Private sub CommandButton1_Click()
Form1.Hide
Form2.Show
End Sub


Private sub CommandButton2_Click()
Form1.Hide
Form2.Hide
Form3.Show
End Sub


Private sub CommandButton3_Click()
Form2.Hide
Form3.Hide
Form1.Hide
End Sub


Gugu

 

[mikerickson]

It would be easier for you to use only one userform with a Multipage control rather than trying to navigate all these different userforms.

Have you tried

Private sub CommandButton3_Click()
Form2.Hide
Form3.Hide
Form1.[COLOR="#FF0000"]Show
[/COLOR]End Sub