How to Stop a Macro Safely?

[game]

I have a for loop and while the macro is running I see an hour glass icon represents loading and does not let me click on any buttons, however I am trying to safely get out of the loop without hitting Ctr + Pause. Does anyone have any experience with this. On top of my for loop I have an if statement.

If stopkey = "0" then
'start loop
end if

And if the stop button is pressed it will make stopkey = "1" however I am unable to press it during when the macro is running.

Any help, thanks.

[rylo]

Hi

Have a look at doevents.

Say you have something like

Sub bbb()
 Do
  DoEvents
  Range("B1") = Range("B1") + 1
 Loop Until Range("A1") = 1
End Sub

Make sure there is nothing in A1, run the code and it will keep incrementing B1. While it is running, you will be able to go to A1, and enter 1. The macro will stop.

HTH

rylo