Unload all userforms

[rinnue]

What I would like to do is have a module that when run will unload all userforms and then show my Home userform. I cannot figure how to do it.

I would like to create a generic module so I do not have to know which userform is open at the time. Just unload all my userforms and show my begining userform again.

Something like:

Private Sub CloseAll()

'unload all forms
Home.Show

End Sub

Thanks

 

[rinnue]

You've brought an end to many hours of frustration. Thankyou.

 

[Bib195]

Forms requires VB. It's not supported by VBA. Use

Sub testIt2()
    Dim i As Long, Str As String
    For i = VBA.UserForms.Count - 1 To 0 Step -1
        Str = Str & VBA.UserForms(i).Name & vbNewLine
        Unload VBA.UserForms(i)
        Next i
    MsgBox Str & "unloaded"
    End Sub

Thank you for such Help... imagine after 13 month of posting this Code, someone else benefited of using it.
Appreciate those people who have the knowledge and willingly supporting others.