View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
dok112[_56_] dok112[_56_] is offline
external usenet poster
 
Posts: 1
Default Userform Question (Load/Unload/Show/Hide)


So, you have a userform that is a "selector" userform, and based on th
combobox selection on that form, another form will initialize, correct
If the wrong selection is made, you want to go back to the origina
userform? Why not put a commandbutton on the 2nd userform that wil
hide the current userform and re-open userform1.

sub commandbutton1_click ()

me.hide
userform1.show

end sub

or a macro that closes all userforms, and then assign that to a comman
button...and after that's done initialize the first form again w
userform1.show...

sub form_close ()
userform1.hide
userform2.hide
userform3.hide
etc...
end sub

if you're looking for something different, let me know, and I'll see i
I understand better

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48069