I have Office 2003 and am writing some code. My question is how do I get
the value of a variable to show up when I move the mouse cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through my code to debug
it and the variables are not displaying their values when I move the mouse
cursor over them. I know I can add a 'watch' also but this is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know why. I've
posted 3 times but no one has any ideas yet. Helllllp... any more ideas?

Thanks,

--
Chet Shannon

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the variable then
click on the quick watch button on the toolbar, that is, the one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question is how do I get
the value of a variable to show up when I move the mouse cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through my code to debug
it and the variables are not displaying their values when I move the mouse
cursor over them. I know I can add a 'watch' also but this is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know why. I've
posted 3 times but no one has any ideas yet. Helllllp... any more ideas?

Thanks,

--
Chet Shannon

Anyone know how to actually fix this so the value of the variable will
display on mouse-over in debug mode? I've happily gotten a few work-arounds
and alternate methods but no fix yet. Should I try the 'detect & repair'
that Office 2003 has possibly?

Thanks, Chet
--
Chet Shannon


"Ben" wrote:

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the variable then
click on the quick watch button on the toolbar, that is, the one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question is how do I get
the value of a variable to show up when I move the mouse cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through my code to debug
it and the variables are not displaying their values when I move the mouse
cursor over them. I know I can add a 'watch' also but this is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know why. I've
posted 3 times but no one has any ideas yet. Helllllp... any more ideas?

Thanks,

--
Chet Shannon

In the VBA editor, 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


"Chet Shannon" wrote in
message
...
Anyone know how to actually fix this so the value of the
variable will
display on mouse-over in debug mode? I've happily gotten a few
work-arounds
and alternate methods but no fix yet. Should I try the 'detect
& repair'
that Office 2003 has possibly?

Thanks, Chet
--
Chet Shannon


"Ben" wrote:

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you
would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the
variable then
click on the quick watch button on the toolbar, that is, the
one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question
is how do I get
the value of a variable to show up when I move the mouse
cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through
my code to debug
it and the variables are not displaying their values when I
move the mouse
cursor over them. I know I can add a 'watch' also but this
is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know
why. I've
posted 3 times but no one has any ideas yet. Helllllp...
any more ideas?

Thanks,

--
Chet Shannon

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet
--
Chet Shannon


"Chip Pearson" wrote:

In the VBA editor, 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


"Chet Shannon" wrote in
message
...
Anyone know how to actually fix this so the value of the
variable will
display on mouse-over in debug mode? I've happily gotten a few
work-arounds
and alternate methods but no fix yet. Should I try the 'detect
& repair'
that Office 2003 has possibly?

Thanks, Chet
--
Chet Shannon


"Ben" wrote:

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you
would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the
variable then
click on the quick watch button on the toolbar, that is, the
one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question
is how do I get
the value of a variable to show up when I move the mouse
cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through
my code to debug
it and the variables are not displaying their values when I
move the mouse
cursor over them. I know I can add a 'watch' also but this
is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know
why. I've
posted 3 times but no one has any ideas yet. Helllllp...
any more ideas?

Thanks,

--
Chet Shannon

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet
--
Chet Shannon


"Chip Pearson" wrote:

In the VBA editor, 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


"Chet Shannon" wrote in
message
...
Anyone know how to actually fix this so the value of the
variable will
display on mouse-over in debug mode? I've happily gotten a few
work-arounds
and alternate methods but no fix yet. Should I try the 'detect
& repair'
that Office 2003 has possibly?

Thanks, Chet
--
Chet Shannon


"Ben" wrote:

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you
would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the
variable then
click on the quick watch button on the toolbar, that is, the
one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question
is how do I get
the value of a variable to show up when I move the mouse
cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through
my code to debug
it and the variables are not displaying their values when I
move the mouse
cursor over them. I know I can add a 'watch' also but this
is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know
why. I've
posted 3 times but no one has any ideas yet. Helllllp...
any more ideas?

Thanks,

--
Chet Shannon

The value can be displayed only when the sub or function is inscope. If
the variable is in a sub or function out of scope no value is displayed.



*** Sent via Developersdex http://www.developersdex.com ***

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet
--
Chet Shannon


"Chip Pearson" wrote:

In the VBA editor, 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


"Chet Shannon" wrote in
message
...
Anyone know how to actually fix this so the value of the
variable will
display on mouse-over in debug mode? I've happily gotten a few
work-arounds
and alternate methods but no fix yet. Should I try the 'detect
& repair'
that Office 2003 has possibly?

Thanks, Chet
--
Chet Shannon


"Ben" wrote:

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you
would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the
variable then
click on the quick watch button on the toolbar, that is, the
one with the
glasses icon.

HTH,
Ben

--



"Chet Shannon" wrote:

I have Office 2003 and am writing some code. My question
is how do I get
the value of a variable to show up when I move the mouse
cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through
my code to debug
it and the variables are not displaying their values when I
move the mouse
cursor over them. I know I can add a 'watch' also but this
is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know
why. I've
posted 3 times but no one has any ideas yet. Helllllp...
any more ideas?

Thanks,

--
Chet Shannon