Stop a loop with a keyboard

[Fernando Ortiz]

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

 

[Harald Staff]

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