Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
Does anybody know if it is possible to add descriptions of arguements
for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
Jonas,
I've never done this but I've read about a method that uses XLM (old-style macros). I googled "xlm macro function arguments description" and got these among others: http://www.bettersolutions.com/excel...N723710331.htm http://www.dailydoseofexcel.com/arch...on-with-excel/ hth, Doug "Jonas" wrote in message ups.com... Does anybody know if it is possible to add descriptions of arguements for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
Hello Jonas
You can add comments on your UDF very simply using the VBE Object Explorer: When in VBE press F2 (to view the Object Explorer) Select your project name from the top dropdown list (eg: VBAProject) Right-click on your function in the "Global members" window Select Properties Add your comments and finsh with OK Save your project Return to Excel and insert your function, you should then be able to see your comments in the Function argumenst window. HTH Cordially Pascal "Jonas" a écrit dans le message de news: ... Does anybody know if it is possible to add descriptions of arguements for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
Jonas
Please replace: Object Explorer with Object Browser and Global Members with Members of... Cordially Pascal "papou" a écrit dans le message de news: ... Hello Jonas You can add comments on your UDF very simply using the VBE Object Explorer: When in VBE press F2 (to view the Object Explorer) Select your project name from the top dropdown list (eg: VBAProject) Right-click on your function in the "Global members" window Select Properties Add your comments and finsh with OK Save your project Return to Excel and insert your function, you should then be able to see your comments in the Function argumenst window. HTH Cordially Pascal "Jonas" a écrit dans le message de news: ... Does anybody know if it is possible to add descriptions of arguements for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
On Oct 18, 2:34 am, "papou"
wrote: Jonas Please replace: Object Explorer with Object Browser and Global Members with Members of... Cordially Pascal "papou" a écrit dans le message denews: %23h%23bDfVEIHA.2__BEGIN_MASK_n#9g02mG7!__...__END ... Hello Jonas You can add comments on your UDF very simply using the VBE Object Explorer: When in VBE press F2 (to view the Object Explorer) Select your project name from the top dropdown list (eg: VBAProject) Right-click on your function in the "Global members" window Select Properties Add your comments and finsh with OK Save your project Return to Excel and insert your function, you should then be able to see your comments in the Function argumenst window. HTH Cordially Pascal "Jonas" a écrit dans le message de news: om... Does anybody know if it is possible to add descriptions of arguements for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements.- Hide quoted text - - Show quoted text - Pascal, Thanks for the response. However, already I knew how to add description pertaining to the function. I want to be able to add a description to an arguement. In addition to what Doug has written, I might try to create a form that has my user-defined functions in it. Maybe I can come up with some code that will have my form appear with my functions rather than the dialog box that now appears when I choose user-defined functions. I'm surprised that the ability to do this isn't available in Excel without creating a form. Maybe that is the problem, I'm not working in Visual Studio; just Excel. If you have any idea on how to associate a help file with the function, please let me know. The section that I see for the place to add it is grey and inaccessible. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Description of Variable for User-Defined Functions
You can add a brief description of your UDF by going to ToolsMacroMacros.
Type in the name of your UDF and "Options". Add a description and hit OK then Cancel. To actually add the arguments you will need something more complex. To fully customize your User Defined Functions.... See Laurent Longre's website for FUNCUSTOMIZE add-in. ZIP file also includes a demo file and a how-to-use file. http://longre.free.fr/english/index.html UNFORTUNATELY................Ballon/Screen Tips are not available with Laurent's method. Gord Dibben Excel MVP On Wed, 17 Oct 2007 21:33:58 -0700, Jonas wrote: Does anybody know if it is possible to add descriptions of arguements for user-defined functions? I am referring to the window that appears when you choose a user-defined function; the "Function Arguments" window. I was able to add a description of the function but I haven't figured out how to add a description for the arguements. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined functions without using VBA. | New Users to Excel | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
excel functions and User defined functions | Excel Programming | |||
User Defined Function description | Excel Programming |