By the way, while I haven't tried to play much with them, there are other
options available in the MacroOptions property. The most noteworthy, in my
opinion, is the Category options where you can set which category of
functions your own function will be listed with. See the help files for the
MacroOptions property (and the example in the Remarks sections) to see how
to use this option.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Use the MacroOptions property of the Application object to do that...

Application.MacroOptions Macro:="FunctionName", Description:="Text to
show"

where you would replace "FunctionName" with your function's name (with
quote marks around it as in my example) and the "Text to show" description
with the description you want to show for your function.

Note that you can't put this statement inside your function... it needs to
be run outside of it, perhaps in the Workbook_Open event procedure.

--
Rick (MVP - Excel)


"BJV" wrote in message
...
I've written several user-defined functions in VB. How do I add the
information or tips that appear at the bottom of the "insert function"
dialog
box so my users will have an idea of what the function does?

Thanks,