How to add a watch to VB expression

[nsharish20]

Hi,

I am using VB and excel and I would like to know how to add a watch to
an expression in VB for some lines of code. When I select a value in
excel and add a watch on a variable, I get Value: <Out of Context>.
Could somebody please explain how to add a watch expression properly
when i select a value in excel. Thanks in advance.

Swamy

[SammyB]

Just a lot of guessing here, but probably you are using late binding in VB6, so VB does not know about any of the Excel objects. If this is the case, (1) add a Reference to Microsoft Excel xx Object Library, (2) put Option Explicit at the top of the module, (3) define all excel objects as Excel. (for example, Dim rng as Excel.Range)

If this is not the case, let us know what VB you are using (VBA, VB6, VB.Net) and how you are getting a reference to the Excel application. HTH --Sam

[Killer42]

Generally speaking, that "out of context" is usually not a problem. It just means you can't see it now. When execution is at the appropriate point, where the item exists, chances are you will be able to see it. Try putting a breakpoint at the line where you copied the reference from, to ensure that it's in context when you look.

Note, though, you may need to include the complete name in the watch, including the parent object.