VBA Debugging with breakpoints

209 views Asked by At

I need to debug part of a VBA code. So I've set a breakpoint in the line I want to start debugging. But after pressing F8 a few times I want the code to run normally (without having to press F8).

How do I do it?

3

There are 3 answers

0
Stefan On

alternatively to play you can use F5 instead.

0
wellimustbedead On

If you want the code to run normally you can press F5 and this will run until complete. However if you want the code to run as normal until a certain point in the code you can insert a breakpoint first by clicking in the margin left of the line you wish the code to break at before pressing F5. This is useful if you wish to skip large amounts of code or long loops etc, but still wish to examine a section of code.

0
Ihidan On

Pressing the play button solves the problem.