I am building a solution that will have many UserForms. I would like to write a script to get a list of the names of the UserForms. I've tried several options and have search the net with little success. The one example I did find looks something like:
Dim Obj As Object
For Each Obj In VBA.UserForms
Debug.Print Obj.name
End If
Next Obj
But there is never anything in the VBA.UserForms. Any suggestions would be appreciated.
Dim Obj As Object
For Each Obj In VBA.UserForms
Debug.Print Obj.name
End If
Next Obj
But there is never anything in the VBA.UserForms. Any suggestions would be appreciated.