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,