It seems both these methods require the user to go to the menu, Insert - functions. Further, If I use the funcustomise.xla, I can't see my own defined functions.

Is there a neat way to display the parameters if the user simply type in the cell? Such as when one types "=normdist(", he will see all the 4 parameters at once.

Thanks,
Steve

"keepitcool" wrote:

function description is easy:
in object browser rightclick the function and type
the description in the function properties.

argument description is not possible unless you use
laurent longre's addin: morefunc.xll
http://longre.free.fr/english/


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Scott Green wrote:

When creating a VBA function for Excel, I would like to add descriptions
for both the function and for the parameters. Any other function I've
used shows, when you insert it as a formula into your spreadsheet, a
description of the function and descriptions for each of the function's
parameters as you are entering data into the "inserting function"
form.

How do I add descriptions to the function and function's parameters for
display when a user inserts my function as a formula into their
spreadsheet?

Thanks.

Scott


---
Message posted from http://www.ExcelForum.com/