ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Interrupting an endless loop (https://www.excelbanter.com/excel-programming/325635-interrupting-endless-loop.html)

davegb

Interrupting an endless loop
 
Since I am new at prgramming in VBA, I'm creating some endless loops.
Hopefully, if I ever get better at this, I won't have the problem. In
the meantime, is there anyway to interrupt an endless loop other than
shutting XL down through the Task Manager?


roman

Interrupting an endless loop
 


"davegb" wrote:

Since I am new at prgramming in VBA, I'm creating some endless loops.
Hopefully, if I ever get better at this, I won't have the problem. In
the meantime, is there anyway to interrupt an endless loop other than
shutting XL down through the Task Manager?




Hit CRL + Pause/Break

Bob Phillips[_6_]

Interrupting an endless loop
 
Hit the Esc key, that should put you into Debug, which you can end. You
might need to hit it a few times to get it recognised.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
ups.com...
Since I am new at prgramming in VBA, I'm creating some endless loops.
Hopefully, if I ever get better at this, I won't have the problem. In
the meantime, is there anyway to interrupt an endless loop other than
shutting XL down through the Task Manager?




davegb

Interrupting an endless loop
 
Will give it a try, Roman!
Thanks for the reply, Bob, but I already tried "Escape" key. Doen't
work.



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

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