Wilmar

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject 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


On Tue, 22 Jun 2004 07:45:43 -0700, WilMar wrote:

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!