How can I see the value of something by hovering my mouse over the line of code?

[rizzo93]

I've been watching video tutorials to learn VBA. Sometimes the user rolls his mouse over a line of code to see the result of that particular code.


Like when you want to see the result of Range("A1").Offset(4,5), you hover over it and you see what the value is.


I couldn't find that configuration in Excel's editor, if it is, in fact, a configuration.


How can make this viewable?

 

[Joe4]

I don't think you have to do anything do make it viewable - it should be like that automatically, I believe.
Note that this only works though while the VBA code is running. So you would either need to run the code in Break mode or step through the code in order to see those values.
(When the code is not running, they have no value, so there is nothing to see).

 

[MickG]

Make sure, In code window try "Tools", "Options", "Auto Data Tips" is clicked.

 

[Joe4]

Make sure, In code window try "Tools", "Options", "Auto Data Tips" is clicked.

I stand corrected. Didn't even know that setting was there!
Thanks for setting me straight, Mick!

 

[rizzo93]

Thanks for the assist, Joe4 and MickG. Cheers!

 

[MickG]

You're welcome
Regrds Mick