Custom function - argument description help

[WilMar]

If you use the Wizard for a standard Excel function, when you click on
the box to enter the argument the Wizard offers a brief help description
(i.e. when VLOOKUP's LOOKUP_VALUE box is clicked you are told
"LOOKUP_VALUE is the value to be found in the first column of the
table..."

How can this be done in a custom function?

Thanks!
Bill

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Bob Umlas Excel MVP]

Even tho functions will not show up in the Run Macro
dialog, you can TYPE the name into this dialog. Use
Tools/Macro/Macros, type the name of your function, then
click the Options button. Enter the description in the
text box shown, and this will be shown to the user as in
VLOOKUP, etc.

 

[Tom Ogilvy]

What Bob describes won't put in a description for the arguments. Those are
not really supported. However, you can use this free addin from Laurent
Longre to do it:


http://longre.free.fr/english/index.html#FunCustomize

 

[Gord Dibben]

Wilmar

You can add a brief description(not arguments) if you open the VBEditor and
View>Object Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

AFAIK the Excel built-in Functions cannot be modified.

Gord Dibben Excel MVP