Testing if Userform loaded
Hi
Thanks for the suggestion, in this case I think it will work. But I may
have more than one form and wanted something to test for a specific form
being in memory. Possible?
something like
If userform1.loaded then
do what i need to do
End If
--
Cheers
Nigel
"Peter T" <peter_t@discussions wrote in message
...
Hi Nigel,
If UserForms.Count = 0 Then
MsgBox "no forms are loaded"
End If
Regards,
Peter T
"Nigel" wrote in message
...
Hi All
How can I test if a userform is loaded in memory?
I have a userform that can be loaded and not visible or just not loaded.
Before I manipulate the controls on the form I need to determine if it is
memory.
Thank You
--
Cheers
Nigel
|