Adding Descriptions to Function Parameters

[Scott Green]

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

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

Thanks.

Scot

 

[keepitcool]

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 >

 

[Tom Ogilvy]

Just to add:
Actually the name of the XLL is
FUNCUSTOMIZE.DLL

Morefunc.xll is also on that page, but it doesn't do the parameter
information.

--
Regards,
Tom Ogilvy

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]

Oh, this is UGLY The function desciption is just right, bu
the argument descriptions method is too awkward.

It's suboptimal, but I guess if it's my only option... I don't want t
distribute an additional DLL in the mix - just a single XLA, but now
have to wrap it all up in an installation utility.

Thanks for the advice.

If you (or anyone else reading this) knows of a more clean way o
adding descriptions to function arguments, please let me know.

Thanks and best regards.

Scot

 

[Tom Ogilvy]

No, (scratch butt), there really isn't another way (pick nose), that I am
aware of (sneeze all over self).

 

[keepitcool]

it's just below (the lack of) project protection on my MShitList.

keepITcool

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

 

[Guest]

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

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 >