Formula palette.

[Guest]

When using built-in functions in excel, the formula palette displays a
description for each of the functions arguments. I would like to create such
a description for my custom functions, is there a way of doing so? (I know
how to provide a FUNCTION description...)

 

[Jean-Yves]

Hi



See http://www.ozgrid.com/VBA/udf-cat-description.htm
Google on : udf xl function description
Regards
JY

 

[Guest]

Hi!
Thank you for respondig, however this is not what I am looking for.
The link you sent me describes how to add descriptions for the function
itself,
what I want is to add argument description, so that when opening the formula
palette, a description can be read for every argument within the function.
For the built-in fuctions in excel, every argument has a description, but how
do I add such a description to custom function variables?

stig

 

[Jean-Yves]

HI
gooble group : vba function argument description
first hit : answer posted by ..............................Tom Ogilvy in
2002
Regards
JY