variable view in VBE
 

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?
--
Trefor

variable view in VBE
 

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 DebugCompile, 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" wrote in message
...
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?
--
Trefor

variable view in VBE
 

Nick, many thanks
--
Trefor


"NickHK" wrote:

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 DebugCompile, 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" wrote in message
...
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?
--
Trefor