Adding argument description to custom functions

  • Thread starter Thread starter philipgoh
  • Start date Start date
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
 
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
 
Back
Top