Hover over VBA variable to get value during execution

[Brad Yundt]

When debugging VBA code in Excel 2000 and later, I find
it quite handy to hold the cursor over a variable to get
its value during code execution. How do I make Excel v.X
do something similar?

I've been sprinkling MsgBox statements throughout my code
as a workaround, but would really prefer to use the hover
feature in combination with F8.

 

[JE McGimpsey]

When debugging VBA code in Excel 2000 and later, I find
it quite handy to hold the cursor over a variable to get
its value during code execution. How do I make Excel v.X
do something similar?

I've been sprinkling MsgBox statements throughout my code
as a workaround, but would really prefer to use the hover
feature in combination with F8.

That feature isn't implemented in the Mac VBE. In addition to (for me,
in preference to) MsgBoxes, use Debug.Print statements which print the
values you specify to the Immediate window. Or type ?<varname> into the
immediate window.