degrees in VBA
 

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 end

degrees in VBA
 

Sounds 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

"damorrison" wrote in message
ups.com...
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 end