View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How show value of variable by mouse-over in debug single step

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