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.

-----Original Message-----
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!
.

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

--
Regards,
Tom Ogilvy

"Bob Umlas Excel MVP" wrote in message
...
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.

-----Original Message-----
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!
.

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!