devxlogo

Prevent Do Loops From Becoming Permanent

Prevent Do Loops From Becoming Permanent

This tip is extremely useful in the IDE for debugging.
Before the Do loop you want to make safe, you set the var ‘loopnum’ as 0. Then, place these two lines inside the loop:

 If loopnum = 99 Then Err.Raise

devx-admin

Share the Post: