View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shellshock[_3_] shellshock[_3_] is offline
external usenet poster
 
Posts: 1
Default Aborting a Sub procedure from a UserForm


I have a Sub procedure that invokes a userform. On the userform there
are a series of radio buttons and two command buttons, one for OK and
one for CANCEL. When the CANCEL button is pressed, I want the userform
to either hide or unload itself -- I know how to do this part -- and I
want the Sub procedure to abort.

How do I do this last part? I can't figure out how to use the CANCEL
button as input to the Sub procedure to get it to abort itself.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=391599