I'm wondering why VBA decides that sometimes it will show the variable value
when I put the cursor over it and sometimes it will not. Forcing me to
create a debug.print VARIABLE everytime I want to make sure things are
progressing properly.?

Hi,

Could you clarify since the only variables for which VBA does not show the
values are object variables for example those defined as Worksheet or
workbook or recordset etc. For those defined as integer,single,double etc, I
have had no problem. Can you post a small piece of your code where you do not
see the values when you hover your cursor over them?

Alok

"HotRod" wrote:

I'm wondering why VBA decides that sometimes it will show the variable value
when I put the cursor over it and sometimes it will not. Forcing me to
create a debug.print VARIABLE everytime I want to make sure things are
progressing properly.?

This isn't a variable problem it's a VBA problem.

There are times when no matter what VARIABLE (Int, String etc.) I hold my
cursor over while in debug mode it will not show me the value. Take the code
below for example if I put my cursor over "MyName" while stepping through
the code Sometimes it will show the value and sometimes it won't show
anything. Even shutting down Excel and reloading it doesn't seem to restart
this.



Dim MyName as String

MyName = "What Ever"

Debug.Print MyName