Navigating between UserForms causing out of stack error

[WernerZiegler]

Hi there,
I'm getting out of stack error when i run my code. Basically i'm trying to create a text based sim sport game so i have many userforms that i work with. For example UserForm1 is my main form (Team page) and on there i have labels that when you click on them it takes you to another UserForm ( for example Label1(standings) when you click on it takes you to UserForm2 , Label3(Schedule) takes you to UserForm3 etc. I'm using this code to navigate between UserForms :

Private Sub Label1_Click()
Unload UserForm1
UserForm2.Show
End Sub
or
Private Sub Label2_Click()
Unload UserForm1
UserForm3.Show
End Sub

When done viewing those other UserForms i have this code to return to UserForm1
Private Sub Label1_Click()
Unload UserForm2
UserForm1.Show
End Sub
or
Private Sub Label1_Click()
Unload UserForm3
UserForm1.Show
End Sub

So eventually this leads to Out of stack error and when i call stack i see all those UserForm.show commands
I'd like to know how can i navigate between UserForms without getting this error. I tried hide method but still the same error. Any idea ?

[torachan]

please read rules regarding code tags to surround your code.

however if you used a multipage on one form you would circumvent all your form closure/hide/show.