degrees in VBA

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top