hi guys

I want to exit my procedure(which is at that point within a loop) when
I press the cancel button on my user form.
Is there a predefined command which will execute the action? Or do I
have to write a code for that.
Please let me know if u have an answer


--
jumpjump
------------------------------------------------------------------------
jumpjump's Profile: http://www.excelforum.com/member.php...o&userid=26568
View this thread: http://www.excelforum.com/showthread...hreadid=400335

Here is some commands that may help you

You will need to attach the code to the cancel button

Exit Do - exit do loop - macro keeps running from code at end of d
loop
Exit For - exit for loop - macro keeps running from code at end of fo
loop
Exit Sub - exit sub routine - if sub routine is called from anothe
macro the macro will continue to run from the calling macro
Exit Function - exit function routine - same as exit sub

End - ends macro from runnin

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=40033

If you are going to exit a running procedure, you will need to allow the
other events

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jumpjump" wrote in
message ...

hi guys

I want to exit my procedure(which is at that point within a loop) when
I press the cancel button on my user form.
Is there a predefined command which will execute the action? Or do I
have to write a code for that.
Please let me know if u have an answer


--
jumpjump
------------------------------------------------------------------------
jumpjump's Profile:
http://www.excelforum.com/member.php...o&userid=26568
View this thread: http://www.excelforum.com/showthread...hreadid=400335