VBA Infinite Loops

[Thaj]

Hi All

I am New to VBA and Need some info about Infinite Loops.

Is there any ways to check whether the code is in Infinte loop or not? If so How to debug where it is going into infinte mode

 

[Marc L]

Hi, as an infinite loop is often just some bad logic …​

​

In order to manually stop an infinite loop add a DoEvents codeline just before the codeline 'ending' the loop​

so the Escape key pressed a while should stop the process.​

​