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

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

Go to ToolsMacroMacros 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


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


.

From Laurant Long

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

but see his later solution at:

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

--
Regards,
Tom Ogilvy


"Dan E" wrote in message
...
Thank you Lance, that's half of what I wanted to do.
Now, if I have a function like

Public Function CellColourCount(ColouredCells As Range) As Integer

How can i make it so that it says
"Coloured cells is the range of cells to be counted"
underneath the description text, kinda like the built in functions do?

Dan E

"Lance" wrote in message
...
I've done this a dozen times before, but it is always hard
to remember this.

Go to ToolsMacroMacros 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


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


.