Create arcTan function

[Tadashii]

Hello,

How can I create a ARCTAN (TAN-1) function in VBA?

Thank

 

[Dave Peterson]

ATAN()

Hello,

How can I create a ARCTAN (TAN-1) function in VBA?

Thanks

 

[Edward Ulle]

Tadashii,

In the VB editor goto help and type in Derived and goto Derived Math
Function. There is a list of useful equations.

For arc or cotangent you could do the following.

Public Function Arctangent(dblValue as Double) As Double
Arctangent = 1# / Tan(dblValue)
End Function

Then in your code to call Arctangent.

dblATan = Arctangent(dblValue)

 

[Tom Ogilvy]

Use the built in Arttan function??

from Excel VBA help:

Atn Function
Returns a Double specifying the arctangent of a number.

 

[Tadashii]

thanks for the info