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/