| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Infinite Loop in Error Handler | Excel Discussion (Misc queries) | |||
| URGENT- Can't get out of infinite loop | Excel Discussion (Misc queries) | |||
| Infinite loop using Worksheet_Calculate | Excel Discussion (Misc queries) | |||
| For Next Infinite Loop | Excel Discussion (Misc queries) | |||
| Infinite Loop | Excel Programming | |||
![TBA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
