Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 573
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 573
Default Interrupting an endless loop

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Endless spreadsheet calculations Zsolt Szabó Excel Discussion (Misc queries) 0 September 22nd 09 03:22 AM
file won't open, endless loop, autorecover lindalou Excel Discussion (Misc queries) 1 January 20th 08 01:26 AM
How can I make endless row, beyond IV column? Luciano New Users to Excel 2 January 23rd 06 04:08 PM
Interrupting a loop Andrea[_8_] Excel Programming 1 April 27th 04 07:47 PM
Endless Loop when using ComboBox1.BoundColumn = 2 shrekut Excel Programming 2 January 12th 04 01:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"