Re: Adding a watch expression in VB
- From: Joel <Joel@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Jun 2007 08:05:01 -0700
You may need to change 180 to 180# to make it a float value.
I sometimes need to break sttatements into pieces to debug problem
a = Sqr(ShapeX ^ 2 + ShapeY ^ 2)
b = ShapeRadius/a
c = Atn(a/b)
d = 180 /PI
e = c * d
"Mahadevan Swamy" wrote:
I defined PI at the very beginning of the program by saying Const PI =.
3.14159265358979.
What is the difference between WorksheetFunction.Pi() and const PI? If
I were to convert to degrees, and using worksheetfunction.Pi(), should
i multiply by 180/PI or 180/PI()?
I have all my variables declared and linked to excel but it is still
not clear why I am getting Empty value when i place my cursor over a
variable?
On Jun 1, 10:18 am, Joel <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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 <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
- Follow-Ups:
- Re: Adding a watch expression in VB
- From: Mahadevan Swamy
- Re: Adding a watch expression in VB
- References:
- Re: Adding a watch expression in VB
- From: Mahadevan Swamy
- Re: Adding a watch expression in VB
- From: Joel
- Re: Adding a watch expression in VB
- From: Mahadevan Swamy
- Re: Adding a watch expression in VB
- Prev by Date: Re: Best/Easiest way to search/find in a string
- Next by Date: Re: UDF won't launch macro
- Previous by thread: Re: Adding a watch expression in VB
- Next by thread: Re: Adding a watch expression in VB
- Index(es):
Relevant Pages
|
