Custom function - argument description help

  • Thread starter Thread starter WilMar
  • Start date Start date
W

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!
 
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.
 
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
 
Back
Top