Simply showing userform2 will not close userform1. It will cause
userform2 to be displayed above (on top of) userform1. To close
userform1, use the Hide method if you want to keep userform1 in
memory (so you can still read values from its controls), or the
Unload statement if you want to dump userform1 from memory.
Either of these statements should be before the Show method of
userform2.




wrote in message
oups.com...
what is the best method of closing a userform,, i know you can
use the
unload userform, but wheres the best place to put this.

i have a form with a few commands buttons on it. from the
command
buttons i only use the call function
i.e call nextsub
then the first line of code within this sub would be unload
userform1.
also i would open another form at the end of this sub using the
userform2.show. Is this enough to ensure userform1 is closed

john