ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HELP - Stuck in loop (https://www.excelbanter.com/excel-programming/359932-help-stuck-loop.html)

gti_jobert[_92_]

HELP - Stuck in loop
 

Hi,

I have a userform thats stuck in a continuous loop displaying a msgbox
- how can I interupt the loop and exit it?

TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=536762


gti_jobert[_93_]

HELP - Stuck in loop
 

Is there a keyboard button I can press that will stop the macro, or do
have to use task manager to close it down - and then loose all my work?

TI

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=53676


Tom Ogilvy

HELP - Stuck in loop
 
If you can't get to the message box, then you will have to use the task
manager to terminate excel.

first try doing Ctrl+C or Ctrl+Break or hit the escape key.

--
Regards,
Tom Ogilvy


"gti_jobert" wrote:


Hi,

I have a userform thats stuck in a continuous loop displaying a msgbox
- how can I interupt the loop and exit it?

TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=536762



gti_jobert[_94_]

HELP - Stuck in loop
 

Thanks so much Tom, I was just about to do it thru the task manager then
saw your reply! ctrl+break worked!

Thanks again!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=536762



All times are GMT +1. The time now is 02:55 AM.

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