View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tony Tony is offline
external usenet poster
 
Posts: 62
Default Excel user-defined functions.

If you put:

Application.MacroOptions Macro:="Fn Name", _
Description:="Short description here"

in the Open event of the workbook containing the
functions, then the description will show up in the Paste
fn window along with the fn name and args. Hardly a full-
blown help function, but it might be useful. Works best
with an AddIn, I think.

Tony


-----Original Message-----
I would like to add descriptions to user-defined function

arguments similar
to "Rate is the interest rate ...." in the FV function.

I would also like to
create seperate categories for my functions instead of

using the default
"User Defined" category in the insert function dialog.

How can I add "Help
on this function" for the user-function I have created.
.