How to see values in code

[ammartino44]

Hello. Sometimes as I hit F8 through code, I can see the values of what's happening for example looping through i. Sometimes I can't though and I'd like to know why!!

Please Login or Register  to view this content.

I would like to see the value of value. Obviously it doesn't meet the criteria it will skip the if message but I'd still like to know haha.

[stnkynts]

In your example the reason you are not seeing the value is because of the declaration of the Sheet, or lack thereof.

Please Login or Register  to view this content.

Note: A lot of time is it prudent to use the immediate window and Debug.Print to see what is happening in code.

[MrShorty]

I use the Watch window for this sort of thing. Set a watch for the desired object, and you will be able to know what is in that variable as you step through the code. http://cis.poly.edu/~mleung/CS394/f0...tchWindow.html

You can also use the debug.print statement in the immediate window to view a variable or objects .value property.

[shg]

The Locals window will show the values of all in-scope variables. I rarely use the Watch window.

[Arkadi]

There is also debug.print which will show up in the Immediate window