| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop a loop with a keyboard
Hi
I need a macro code easy to understand for the following problem. I have a many records in the worksheet and need in some cases stop the macro loop with press any key; example Space Bar. its that possible? Thanks for your expertice advice Regards, Fernando Ortiz |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stop a loop with a keyboard
Hi Fernando
It's a little complex, but see the working solution CheckKey on Stephen Bullen's page http://www.bmsltd.co.uk/Excel/Default.htm -- HTH. Best wishes Harald Followup to newsgroup only please "Fernando Ortiz" skrev i melding ... Hi I need a macro code easy to understand for the following problem. I have a many records in the worksheet and need in some cases stop the macro loop with press any key; example Space Bar. its that possible? Thanks for your expertice advice Regards, Fernando Ortiz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find keyboard short-cut to type symbols on keyboard | Excel Discussion (Misc queries) | |||
| Find loop doesn't loop | Excel Discussion (Misc queries) | |||
| Stop a loop when certain data is found | Excel Discussion (Misc queries) | |||
| What causes my number pad on my keyboard to suddenly stop functio. | Excel Discussion (Misc queries) | |||
| newbie: stop a FOR NEXT loop | Excel Programming | |||
Hybrid Mode
