Create arcTan function
 

Hello,

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

Thank

--
Tadashi
-----------------------------------------------------------------------
Tadashii's Profile: http://www.excelforum.com/member.php...fo&userid=2391
View this thread: http://www.excelforum.com/showthread.php?threadid=50167

Create arcTan function
 

ATAN()

Tadashii wrote:

Hello,

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

Thanks

--
Tadashii
------------------------------------------------------------------------
Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918
View this thread: http://www.excelforum.com/showthread...hreadid=501675

--

Dave Peterson

Create arcTan function
 

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)

*** Sent via Developersdex http://www.developersdex.com ***

Create arcTan function
 

Use the built in Arttan function??

from Excel VBA help:

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

----------------------------------------------

See help for details

--

Regards,

Tom Ogilvy



"Tadashii" wrote in
message ...

Hello,

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

Thanks


--
Tadashii
------------------------------------------------------------------------
Tadashii's Profile:
http://www.excelforum.com/member.php...o&userid=23918
View this thread: http://www.excelforum.com/showthread...hreadid=501675

Create arcTan function
 

thanks for the info


--
Tadashii
------------------------------------------------------------------------
Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918
View this thread: http://www.excelforum.com/showthread...hreadid=501675