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

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