Debug Excel 2003

[Wild_Jim]

I have just upgraded to Excel 2003 and when I use the debugger to "step
through" a program, I can no longer hover over variables to see their
values - is there an option to turn this on?

Thanks in advance.

[Nick Hodge]

Jim

'Show tooltips' under tools>options>general in the VBE controls this
(Alt+F11)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Wild_Jim" <[email protected]> wrote in message
news:[email protected]...
>I have just upgraded to Excel 2003 and when I use the debugger to "step
>through" a program, I can no longer hover over variables to see their
>values - is there an option to turn this on?
>
> Thanks in advance.
>

[Wild_Jim]

Thanks for this, but my option was already ticked.
I have tried various approaches, but I cannot get the thing to work at tun
time. Any more ideas? - It really is a pain not being able to see the values
of variables - Im currently adding a watch, but that is not as easy.

"Nick Hodge" <[email protected]> wrote in message
news:%[email protected]...
> Jim
>
> 'Show tooltips' under tools>options>general in the VBE controls this
> (Alt+F11)
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> [email protected]HIS
>
>
> "Wild_Jim" <[email protected]> wrote in message
> news:[email protected]...
>>I have just upgraded to Excel 2003 and when I use the debugger to "step
>>through" a program, I can no longer hover over variables to see their
>>values - is there an option to turn this on?
>>
>> Thanks in advance.
>>
>
>

[Chip Pearson]

In VBA, go to the Tools menu, choose Options, then the Editor
tab. There, ensure that "Auto Data Tips" is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wild_Jim" <[email protected]> wrote in message
news:[email protected]...
> Thanks for this, but my option was already ticked.
> I have tried various approaches, but I cannot get the thing to
> work at tun time. Any more ideas? - It really is a pain not
> being able to see the values of variables - Im currently adding
> a watch, but that is not as easy.
>
> "Nick Hodge" <[email protected]> wrote in
> message news:%[email protected]...
>> Jim
>>
>> 'Show tooltips' under tools>options>general in the VBE
>> controls this (Alt+F11)
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> [email protected]HIS
>>
>>
>> "Wild_Jim" <[email protected]> wrote in message
>> news:[email protected]...
>>>I have just upgraded to Excel 2003 and when I use the debugger
>>>to "step through" a program, I can no longer hover over
>>>variables to see their values - is there an option to turn
>>>this on?
>>>
>>> Thanks in advance.
>>>
>>
>>
>
>