close all open userforms

[ladbroke]

Is there a code i can attach to a commandbutton that once clicked will close all current open userforms...

I may have more than one, and not any specific one, open at anytime and would want them to close when pressed.

 

[Jonmo1]

this should do

For Each form In UserForms
form.Hide
Next form

 

[ladbroke]

it appears to just hide the userforms rather than close them

 

[Jonmo1]

I didn't know the difference....
Just apply whatever the command is to close...

form.close or
form.unload

 

[Lewiy]

Slightly off track, what is the difference between hiding and closing? I've always used .Hide and never had any trouble.

 

[ladbroke]

Is there a code...

Ive re-tried the original one and it doesn't really do what i want it to do.

I really would like to be able to close all open userforms..

I will tend to have just 2 userforms open at 1 time. When a commandbutton is clicked, i would really like to close the 2 open forms and then open the form of the button clicked.

can someone please post a code that will work?

 

[jindon]

how about

For i = UserForms.Count To 1 Step - 1
     Unload UserForms(i)
Next

 

[ladbroke]

for some reason it keeps coming up that i need to debug the Unload Userforms(i) line...

Why isn't this working?

 

[jindon]

is that

For i = UserForms.Coutn -1 To 0 Step -1
     Unload UserForms(i)
Next