View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default Detecting an endless loop in the VB Editor

On Jun 7, 3:01 am, Raj wrote:
Hi,

In events programming, not using Application.enableevents = True and
False code comibination may result in an endless loop.

Is there any way to detect whether an endless loop has been
trigerred? Is there any indication in the VB editor to indicate that
there is currently no endless loop running?

I am asking this as it may take quite some time before the system runs
out of resources because of the endless loop.

Thanks in advance for the help.

Regards,
Raj

Hi,
Click Ctrl-Break to stop the loop,
lets see the code....