Programatically stop macro

[John Yazou]

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]

Would something like this do the trick?


Private Sub CancelButton1_Click()
Userform1.Hide
End
End Sub

Rgds
AJ

 

[Legacy 98055]

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]

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

 

[Legacy 98055]

Correct
Dim Public in standard mod