Adding Descriptions to Function Parameters
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 |
Adding Descriptions to Function Parameters
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/ |
Adding Descriptions to Function Parameters
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/ |
Adding Descriptions to Function Parameters
Oh, this is UGLY :rolleyes: 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 |
Adding Descriptions to Function Parameters
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 :rolleyes: 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/ |
Adding Descriptions to Function Parameters
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). |
Adding Descriptions to Function Parameters
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/ |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com