Custom Functions used through the wizard

[Dan E]

When I write a custom function, how do I get the function wizard to display
comments about my inputs?

ie when you use SUMIF and your cursor is in the Range field it shows:
Range is the range of cells you want evaluated

I would like to be able to add retard proofing comments such as these to my
functions!

Dan E

 

[Lance]

I've done this a dozen times before, but it is always hard
to remember this.

Go to Tools>Macro>Macros and type in the name of your
Function(Functions don't show on the Macros list). Then
hit the "Options" button and type your description in
there.

Now when you select your Function from the UDF category,
it will have your description/text.

Lance

 

[Tom Ogilvy]

From Laurant Longre:

http://longre.free.fr/english/func_cats.htm

but see his later solution at:

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