totn Excel 2013 VBA Debugging

MS Excel 2013: Check Values in VBA

This Excel tutorial explains how to check values in the VBA debugging environment in Excel 2013 (with screenshots and step-by-step instructions).

Checking values

In Excel 2013, if you want to view the value of a variable in your VBA code at the time that the program was suspended, you can move your mouse pointer over that VBA code. Bubble text will appear displaying the variable/expression name and its value in its current state.

Microsoft Excel

In this example, we've moved the mouse pointer over the expression pValue. The bubble text displays the expression name with a value of "123 Main St".

This feature is useful if you need to quickly check a variable/expression in your code.