Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm performing a series of operations on cells within the used range of a s/sheet. A summary of the code is as follows: Dim c as range on error goto errhandler Application.EnableCancelKey = xlErrorHandler For Each c In ActiveSheet.UsedRange .....series of operations on each cell.... next c exit sub errhandler: end sub I'd like to give the user the option of breaking out of the loop using the escape key. However the code stubbornly refuses to do this in practice... I've tried using "doevents" without any luck - although I'm not sure that I'm applying it correctly. Suggestions.... Rgds....Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax for stopping a Do Loop? | Excel Discussion (Misc queries) | |||
Status bar (or similar) to appear whilst running a long macro | Excel Discussion (Misc queries) | |||
How do I pause a Macro whilst it is running? | Excel Programming | |||
How to Mute/Enable Windows Sounds whilst running VBA code | Excel Programming | |||
How to Mute/Enable Windows Sounds whilst running VBA code | Excel Programming |