degrees in VBA

  • Thread starter Thread starter damorrison
  • Start date Start date
D

damorrison

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
 
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
 
Back
Top