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


.