Cancel a Procedure through a Userform
 

hi guys

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

thanks in advanc

--
jumpjum
-----------------------------------------------------------------------
jumpjump's Profile: http://www.excelforum.com/member.php...fo&userid=2656
View this thread: http://www.excelforum.com/showthread.php?threadid=40031

Cancel a Procedure through a Userform
 

If you want to cancel running code, then you need to give the cancel button
a look in. This can be done by issuing DoEvents intermittently in the
running procedure.

Here is a simple example, two buttons on the form, one to start the code,
one to cancel.

Private Sub CommandButton1_Click()
Dim i As Long
For i = 1 To 1000000
Application.StatusBar = "Processing " & i
DoEvents
Next i

End Sub

Private Sub CommandButton2_Click()
Unload Me
End
End Sub


--

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

thanks in advance


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