totn Excel 2011 VBA Debugging

MS Excel 2011 for Mac: Clear Breakpoint in VBA

This Excel tutorial explains how to clear a breakpoint in the VBA debugging environment in Excel 2011 (with screenshots and step-by-step instructions).

Clearing a Breakpoint

A breakpoint in VBA is indicated by a red dot with a line of code highlighted in red.

To clear a breakpoint in Excel 2011, left-click on the red dot next to the line of code that has the breakpoint.

Microsoft Excel

In this example, we want to clear the breakpoint at the following line of code:

LFraction = pValue - LWhole

Microsoft Excel

Now, the breakpoint is cleared and the line of code should look normal again.