ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   loop whole sub (https://www.excelbanter.com/excel-programming/417130-re-loop-whole-sub.html)

Mike H

loop whole sub
 
Hi,

Do
'your code
Loop

Would loop endlessly and can be stopped by pressing Ctrl+Break or Esc.
Whether it would work on your code would depend on that code.

Mike

"Sandy" wrote:

How can I loop an entire sub repeatedly until I make a key press (e.g.
"esc") or something similar.

tia
Sandy



All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com