software

I would like to have a Label in a UserForm to show the result of a
degrees formula,
On a calculator I would just go 1/x then inverted tan to get my degrees
how is this done in a vba
in label 20 I want it to show
1/textbox8 then inverted tan to get the degrees?

Also is there a way to to have the result values change as new data is
inputted into text boxes, right now I am using textbox change to
initiate a formula but if I go back to another box in the beginning and
change a value, the result won't change unless, because the textbox
change is closer to the endSounds like you want the ATN function
Be aware the result will be in radians. To convert to degrees, multiply by
180/PI (or use application.worksheetfunction.radians()
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;damorrisonquot; gt; wrote in message ups.com...
gt;I would like to have a Label in a UserForm to show the result of a
gt; degrees formula,
gt; On a calculator I would just go 1/x then inverted tan to get my degrees
gt; how is this done in a vba
gt; in label 20 I want it to show
gt; 1/textbox8 then inverted tan to get the degrees?
gt;
gt; Also is there a way to to have the result values change as new data is
gt; inputted into text boxes, right now I am using textbox change to
gt; initiate a formula but if I go back to another box in the beginning and
gt; change a value, the result won't change unless, because the textbox
gt; change is closer to the end
gt;