Programatically stop macro

John Yazou · Apr 4th, 2002, 02:14 AM

Hi guys..
Say I have a macro XX running... & I have a useform with a Stop Macro command button. How, if its possible, to stop XX using the cmdbutton_click() event handler??

AJ · Apr 4th, 2002, 02:25 AM

Would something like this do the trick?

Private Sub CancelButton1_Click()
Userform1.Hide
End
End Sub

Rgds
AJ

Tom Schreiner · Apr 4th, 2002, 02:31 AM

End can be dangerous.
To stop a seperate process, use a Global flag. Place a line in such as this...
If ExitNow Then Exit Sub
Assign the boolean ExitNow as True with your commandbutton.
Tom

John Yazou · Apr 4th, 2002, 03:07 AM

Gotcha... thanks... so basically I will modify XX to check the global variable upon entry, exit or mid-way or something right??

Tom Schreiner · Apr 4th, 2002, 03:16 AM

Correct
Dim Public in standard mod

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 02:14 AM	#1
John Yazou New Member Join Date: Mar 2002 Posts: 49	Hi guys.. Say I have a macro XX running... & I have a useform with a Stop Macro command button. How, if its possible, to stop XX using the cmdbutton_click() event handler??

Apr 4th, 2002, 02:25 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Would something like this do the trick? Private Sub CancelButton1_Click() Userform1.Hide End End Sub Rgds AJ

Apr 4th, 2002, 02:31 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	End can be dangerous. To stop a seperate process, use a Global flag. Place a line in such as this... If ExitNow Then Exit Sub Assign the boolean ExitNow as True with your commandbutton. Tom

Apr 4th, 2002, 03:07 AM	#4
John Yazou New Member Join Date: Mar 2002 Posts: 49	Gotcha... thanks... so basically I will modify XX to check the global variable upon entry, exit or mid-way or something right??

Apr 4th, 2002, 03:16 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Correct Dim Public in standard mod