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