Here's one way to get a list of UserForms in Excel.
Code:
Sub list_user_forms()
Dim Obj As Object
For Each Obj In ThisWorkbook.VBProject.VBComponents
If Obj.Type = 3 Then
Debug.Print Obj.Name
End If
Next Obj
End Sub