Adding argument description to custom functions

P

philipgoh

Hi

does anyone knows how to add description to custom functions' arguments
so that a description of each argument can be displayed in the formula
palette?

thanks
 
T

Tom Ogilvy

VBA functions don't support text descriptions in the Function wizard.

You can look at the information Laurent Longre has posted on his site about
this:

http://longre.free.fr/english/func_cats.htm

Newer addin that supports this:
http://longre.free.fr/english/index.html#FunCustomize

here is some peripheral information you might find useful:


http://support.microsoft.com/default.aspx?scid=kb;en-us;277017
XL2000: Cannot See User-Defined Function in the Paste Function Dialog Box

http://support.microsoft.com/default.aspx?scid=kb;EN-US;213645
XL2000: How to Use a Custom Function in Another Workbook

http://support.microsoft.com/default.aspx?scid=kb;en-us;142123
XL: How to Remove User-Defined Functions from Function Wizard

http://support.microsoft.com/default.aspx?scid=kb;en-us;151490
XL: How to Create a Global User-Defined Function

http://support.microsoft.com/default.aspx?scid=kb;en-us;213813
XL2000: How to Add a New Category to Function Category List

As far as assigning a help file to the macro, that is done in the
macrooptions method of the application.object. I haven't done it, so I
don't know if that will work with the help on this function button

http://support.microsoft.com/default.aspx?scid=kb;en-us;157108
XL97: Options Not Available in Macro Options Dialog Box
 
Top