Check whether form is open

[nickjar2]

Also, how would I check whether a user form is loaded/unloaded in Excel. Would the isLoaded function in Access work if I import it, or does Excel has its own method?

Cheers,

Nick

 

[bonina]

hi,
One way that works well is to write your own isloaded function that simply loops through the Userforms collection to see if the name of the form you're looking for exists.

 

[nickjar2]

Hi,

How do I access the user forms collection? Is it similar to how it is done in Access. My excel knowledge is getting better but I still have a long way to go.

Cheers,

Nick