Clicking to open/hide a userform

[Jaybe08]

Background: I'm new to Excel VBA, so please bear with me.

Issue: I have two userforms. One main userform (Userform1) and another userform (Userform2) that the user can choose to open and close.
How can I implement this?
I've searched this forum and attempted to solve it like this (but I doesn't work):

Private Sub cmdShow_Click()

If Userform1.ActiveControl Is Nothing Then

Userform2.Show
​

Else

Unload Userform2
​

End If
​

I appreciate any help.
Thanks!

 

[Smitty]

Welcome to the Board!

Are they going to open UF2 from UF1? If so it'd just be:

Private Sub cmdShow_Click() 
  Unload Me
  Userform2.Show
End Sub

HTH,

 

[Jaybe08]

I want the main userform to stay open. But I was able to find this code, which worked.

Function IsUserFormLoaded(UserFormName As String) As Boolean
Dim UF As Object
For Each UF In UserForms
If UCase(UF.Name) = UCase(UserFormName) Then
IsUserFormLoaded = True
Exit Function
End If
Next
End Function

Thanks for your help though.