J
JulieD
Hi All
i have code that should unload a userform when it has finished running the
code associated with it, but i've found that it doesn't always do it .. so i
would like on the initialization of the "menu" userform to ensure that all
other userforms are closed e.g.
on error resume next
unload userform1
unload userform2
etc
however, i've noticed that when stepping through this code the form
initialization code runs for each of the userforms whether or not they are
displayed - which slows down the code somewhat.
i know that i can check to see if a userform is visible, and if it is to
close it
e.g.
if userform1.visible = true then
unload userform1
end if
if userform2.visible = true then
unload userform2
end if
but i'm wondering if there is a more efficient way of doing this. (Excel
2000 btw)
Cheers
JulieD
i have code that should unload a userform when it has finished running the
code associated with it, but i've found that it doesn't always do it .. so i
would like on the initialization of the "menu" userform to ensure that all
other userforms are closed e.g.
on error resume next
unload userform1
unload userform2
etc
however, i've noticed that when stepping through this code the form
initialization code runs for each of the userforms whether or not they are
displayed - which slows down the code somewhat.
i know that i can check to see if a userform is visible, and if it is to
close it
e.g.
if userform1.visible = true then
unload userform1
end if
if userform2.visible = true then
unload userform2
end if
but i'm wondering if there is a more efficient way of doing this. (Excel
2000 btw)
Cheers
JulieD