Testing to find if UserForm is Loaded
Why not use and If ...Then statement:
If UserForm1.Visible = True Then
'Do something
Else
UserForm1.Show
'Do something
End If
"DanB" wrote in message
...
I have multiple userforms open and hidden.
How can I test to see if a userform is loaded before attempting to either
Unload or change attributes to any controls contained therein?
thanks,
DanB
|