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

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

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/

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

"keepitcool" wrote in message
...
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/

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

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

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

--
Regards,
Tom Ogilvy

"Scott Green " wrote in message
...
Oh, this is UGLY The function desciption is just right, but
the argument descriptions method is too awkward.

It's suboptimal, but I guess if it's my only option... I don't want to
distribute an additional DLL in the mix - just a single XLA, but now I
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 of
adding descriptions to function arguments, please let me know.

Thanks and best regards.

Scott


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

it's just below (the lack of) project protection on my M****List.

keepITcool

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


"Tom Ogilvy" wrote:

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

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/