View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] john.9.williams@bt.com is offline
external usenet poster
 
Posts: 104
Default closing userforms

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