Cancel a Procedure through a Userform

[jumpjump]

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

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>