Test if a Userform is loaded or activated??
Hi
Use the Visible property of the userform to test if it is visible:
If Userform1.Visible=True Then
'Userform is visible
Else
'Userform is not visible
End If
Regards,
Per
"Robert Crandal" skrev i meddelelsen
...
My userform only appears or activates when an event
occurs on my spreadsheet. How can I test whether
or not the Userform is currently loaded or visible??
Does the Userform object have a property or flag
I can check to see if the form is loaded??
thank u
|