Find active UserForms 1

[daseffects]

I have a few forms which are shown based on various triggers. WHat I would like is a way to see which userforms are open and the unload them.

I've tried just stating

unload Userform1
unload Userform2
unload Userform3

But I get an error message if one of the forms has already been closed. I couldn't find and active userform commands.

Thanks for any help on this.
D

 

[Bowers74]

Try this:

On Error Resume Next
unload Userform1 
unload Userform2
unload Userform3

This way, you don't have to know which User Form is loaded. If your code causes an error on one line it simply goes to the next line of code.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!