variable view in VBE

[Trefor]

When you are in VBE stepping through code you can hover the mouse over a
variable and it will display what the variable is currently set to. This is
very handy when you are trying to debug code. 'Sometimes' this stops working,
I have no idea why and often if I close Excel and restart it will work fine
again. Am I somehow turning off an option somewhere? Does anyone know how to
turn this feature back on?

 

[NickHK]

Trefor,
I normally find this happens when you have an error in your code, but it is
not immediate enough to stop compilation or current running.
If you try Debug>Compile, you may get compilation errors indicated that you
weren't aware of. This obviously can't help with run-time errors.

Other times I do find Intellisense takes a coffee break, only to return for
no apparent reason.

But errors are normally the reason.

NickHK

 

[Trefor]

Nick, many thanks
--
Trefor

Trefor,
I normally find this happens when you have an error in your code, but it is
not immediate enough to stop compilation or current running.
If you try Debug>Compile, you may get compilation errors indicated that you
weren't aware of. This obviously can't help with run-time errors.

Other times I do find Intellisense takes a coffee break, only to return for
no apparent reason.

But errors are normally the reason.

NickHK