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

the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:

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

All the VB codes are written in a module and I don't know how to
execute this module. When I try to press Run button, I get to run some
other macro but not this module. In a module I have different
functions and I want to execute those functions. Is there a way to
do that?

Thanks
Swamy


On May 31, 11:48 am, Joel wrote:
the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:
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

Left Click on the subroutine (any place) then start macro F5- Run F8-Step

"Mahadevan Swamy" wrote:

All the VB codes are written in a module and I don't know how to
execute this module. When I try to press Run button, I get to run some
other macro but not this module. In a module I have different
functions and I want to execute those functions. Is there a way to
do that?

Thanks
Swamy


On May 31, 11:48 am, Joel wrote:
the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:
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

Is there a way to evaluate the results of IF, OR, AND statements to
see whether the result comes out to be True or False?

Also when I assign a variable to a formula and when I debug the code,
the variable comes out to be Empty. What's wrong?

Eg. Beta = Atn(ShapeRadius / (Sqr(ShapeX ^ 2 + ShapeY ^ 2))) * (180 /
PI)

Value of Beta: False?

Can you please clarify

Thanks



On May 31, 2:28 pm, Joel wrote:
Left Click on the subroutine (any place) then start macro F5- Run F8-Step

"Mahadevan Swamy" wrote:
All the VB codes are written in a module and I don't know how to
execute this module. When I try to press Run button, I get to run some
other macro but not this module. In a module I have different
functions and I want to execute those functions. Is there a way to
do that?

Thanks
Swamy

On May 31, 11:48 am, Joel wrote:
the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:
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

the value of PI doesn't have a value try this
WorksheetFunction.Pi()

You can add to the watch formulas such as ShapeX ^ 2 + ShapeY ^ 2
wqatch items can be more than just one variable.

False is defined as zero and true is any value that is not zero. If you
don't havve you variables declared whan you get a value of zero VBA doesn't
know if zero means false or the number zero.

"Mahadevan Swamy" wrote:

Is there a way to evaluate the results of IF, OR, AND statements to
see whether the result comes out to be True or False?

Also when I assign a variable to a formula and when I debug the code,
the variable comes out to be Empty. What's wrong?

Eg. Beta = Atn(ShapeRadius / (Sqr(ShapeX ^ 2 + ShapeY ^ 2))) * (180 /
PI)

Value of Beta: False?

Can you please clarify

Thanks



On May 31, 2:28 pm, Joel wrote:
Left Click on the subroutine (any place) then start macro F5- Run F8-Step

"Mahadevan Swamy" wrote:
All the VB codes are written in a module and I don't know how to
execute this module. When I try to press Run button, I get to run some
other macro but not this module. In a module I have different
functions and I want to execute those functions. Is there a way to
do that?

Thanks
Swamy

On May 31, 11:48 am, Joel wrote:
the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:
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