Category Archives: Excel

Worksheetfunction vs UDF

Posted on 23/02/2008 by dougaj4

The previous post provided VBA code for a number of trigonometric functions, most of which are already available in Excel.  Why bother you may say, why not just use the WorksheetFunction object?  The numbers below provide the answer: Time to … Continue reading →

Posted in Excel, UDFs | Tagged | 7 Comments

Trigonometric Functions in VBA

Posted on 23/02/2008 by dougaj4

Deep within the bowels of the Microsoft on-line help can be found: http://msdn2.microsoft.com/en-us/library/csfk8t62(VS.85).aspx which lists  the derivation of trigonometric functions not provided by VBA.  Not included in this list is ATan2(), which is strange because this is the one trigonometric … Continue reading →

Posted in Excel, Maths, UDFs | Tagged | 7 Comments

Hello World in a UDF

Posted on 21/02/2008 by dougaj4

An Excel User Defined Function (UDF) is probably the single most useful feature that remains unused by the majority of users. This post will provide a brief introduction with the obligatory “Hellow World” program, followed by something only a little … Continue reading →

Posted in Excel, UDFs | Tagged , | 4 Comments