Trigonometric Functions in VBA – Update

In this post from February a set of VBA trigonometric functions were presented, using the derivations given on the Microsoft Developer Network site:

Derived Math Functions

Unfortunately two of the functions were wrong; the correct versions are shown below:

Inverse Secant Arcsec(X) = Atn(1 / Sqr(X * X – 1)) + Sgn((X) -1) * (2 * Atn(1))
Inverse Cosecant Arccosec(X) = Atn(1 / Sqr(X * X – 1)) + (Sgn(X) – 1) * (2 * Atn(1))

I have corrected the spreadsheet, which can be downloaded from: VBA Trig Functions

Does anyone know how I can notify Microsoft of the error?

This entry was posted in Excel, Maths, Newton, UDFs, VBA and tagged , , . Bookmark the permalink.

5 Responses to Trigonometric Functions in VBA – Update

  1. gary says:

    no guarantees, but i’ve used this in the past.


  2. jonpeltier says:

    Hi Doug –

    Apparently if you have login credentials (what used to be called Passport, but now it’s anyone’s guess), you can submit comments to the MSDN articles. I’ve done that just now.

    I don’t know whether anyone monitors or moderates the comments. I’ll try to remember to check back in a month.


  3. dougaj4 says:

    Thanks Gary and Jon.

    We’ll see if we get any response.


  4. dougaj4 says:

    I sent a message to xlfiles, and got a nice reply from Dave Gainer, who said he’d forward it to the right people, but it might take a few days.


  5. Pingback: Daily Download 23: Trigonometric Functions in VBA and Fortran | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s