HOWTO: Insert Custom Function

[Andris]

Hi,

Simple but tricky question here: I made myself a nice custom function called ANDRIS how do I get it to be accepted by Excel so that I can type =ANDRIS(A1) in any cell, just as you can do with any other function ? If possible I would like it to be in the list with functions as well, together with its description etc.

 

[XL-Dennis]

Andris,

Place the workbook with the UDF in the XLStart-folder or if You will just use it for specific workbook set a reference via Tools | Reference in the VB-editor.

HTH,
Dennis

 

[Swamp Thing]

If you plan to use the udf in only one workbook, just paste the function into a standard module (NOT into a worksheet module). The function will immediately become available in all worksheets. It will appear under "User Defined" in the function wizard, ie via the f(x) button.

If you want it to be usable in all workbooks, search this forum for threads on Add-ins for information on how to create an add in containing your own function(s).

To add descriptions to your udf and to list it in a given category of the function wizard, see:
http://www.ozgrid.com/VBA/DesciptionToUDF.htm
This message was edited by Swamp Thing on 2002-08-26 03:27