ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HELP!!!! Can't stop a loop (NOT an infinite loop) (https://www.excelbanter.com/excel-programming/285395-help-cant-stop-loop-not-infinite-loop.html)

TBA[_2_]

HELP!!!! Can't stop a loop (NOT an infinite loop)
 
Stupid me is displaying a Message Box every time through a loop for testing,
but stupid me forgot to shorten the loop. I really don't want to click OK
45,000 times. How do I stop it?!?!

Help!!!!

-gk-



Chip Pearson

HELP!!!! Can't stop a loop (NOT an infinite loop)
 
GK,

While the Msgbox is displayed, press CTRL+BREAK, then click the
Debug button, and comment out your MsgBox.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"TBA" wrote in message
...
Stupid me is displaying a Message Box every time through a loop

for testing,
but stupid me forgot to shorten the loop. I really don't want

to click OK
45,000 times. How do I stop it?!?!

Help!!!!

-gk-





John Wilson

HELP!!!! Can't stop a loop (NOT an infinite loop)
 
gk,

Ctrl + Break should get you out of the loop.

John


"TBA" wrote in message
...
Stupid me is displaying a Message Box every time through a loop for

testing,
but stupid me forgot to shorten the loop. I really don't want to click OK
45,000 times. How do I stop it?!?!

Help!!!!

-gk-





TBA[_2_]

HELP!!!! Can't stop a loop (NOT an infinite loop)
 
Whew!!

Thank you oh so much.

Silly me.

-gk-

"Chip Pearson" wrote in message
...
GK,

While the Msgbox is displayed, press CTRL+BREAK, then click the
Debug button, and comment out your MsgBox.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"TBA" wrote in message
...
Stupid me is displaying a Message Box every time through a loop

for testing,
but stupid me forgot to shorten the loop. I really don't want

to click OK
45,000 times. How do I stop it?!?!

Help!!!!

-gk-








All times are GMT +1. The time now is 01:24 PM.

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