Checking for User Form loaded

[scottintexas]

How can I test to see if a user form is loaded. If I try to access any item on the user form my code goes right into the form initialize to begin loading it. What I would like to do is test to see if the form is loaded.

[Richard Buttrey]

How can I test to see if a user form is loaded. If I try to access any item on the user form my code goes right into the form initialize to begin loading it. What I would like to do is test to see if the form is loaded.

Hi,

Untested but perhaps something like:

Please Login or Register  to view this content.

[scottintexas]

Thanks for the reply.

What I ended up doing is setting a global variable true when the form is loaded and false when unloaded so I can just check the variable. DUH!

Again, thanks for your help.

[Leith Ross]

Hello scottintexas,

You can check if any forms are loaded by checking the Count property of the UserForms collection. The most recently loaded form is at index zero.

Please Login or Register  to view this content.

To check if a particular form has been loaded, you have to loop through the collection and check the form name. The UserForms collection object only accepts a number for the index. This code example returns the index number in the collection for the UserForm named "UserForm1"

Please Login or Register  to view this content.

Sincerely,
Leith Ross