Create arcTan function

[Tadashii]

Hello,

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

Thanks

[Dave Peterson]

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

[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)

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

[Tom Ogilvy]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Tadashii]

thanks for the info