Userform show / hide

[TheWennerWoman]

Hello,

I have a userform, call it UserForm1. It contains five buttons. If the user clicks button1 I have some simple code that does

Private Sub CommandButton1_Click()
UserForm2.Show
End Sub

UserForm2 appears with whatever data I have populated it with. That userform has a QUIT button which has some code that does

Private Sub CommandButton1_Click()
Unload Me
End Sub

UserForm1 is then visible again.

I've had a couple of instances (sporadic) where UserForm1 has remained visible on top of UserForm2. Clicking on UserForm2 makes UserForm1 disappear. I don't know if Excel is just having a moment but this file is aimed at very non-techy people and two forms visible is going to confuse them.

Is there a way of forcing UserForm1 to disappear and then reappear once UserForm2 is closed so that I can be sure only one form is visible at any one time?

This is in a corporate environment so calls to the API aren't an option.

Thanks for reading!

 

[mikerickson]

You could try this in UF1's code that calls UF2.

Private Sub CommandButton1_Click()
    Me.Hide
    UserForm2.Show
    Me.Show
End Sub