Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference Escape and Ctrl + Break to interrupt code
Have a bit of code with this simplified construction:
Sub Test() On Error GoTo STOPTEST Application.EnableCancelKey = xlErrorHandler OtherSub Do While Condition = True DoEvents OtherSub DoEvents Loop STOPTEST: MsgBox "Stopped Test" End Sub Now when I am in the Sub OtherSub the Escape key will interrupt this code and go to STOPTEST, but not when I am in the Do While loop and not in OtherSub. Ctrl + Break/Pause will work in both situations. What could be the explanation for this? Ideally I would like the Escape key to work in both situations. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
Ctrl+Alt+Break | Excel Programming | |||
Can Not Get Macro to Break with CTRL-BREAK | Excel Programming | |||
Control Break and Escape for Interrupting Code | Excel Programming | |||
Message box that does not interrupt code | Excel Programming |