Checking for User Form loaded

Originally Posted by 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.

Hi,

Untested but perhaps something like:

Please Login or Register  to view this content.

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