Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function Properties
Thanks for taking the time to read my question.
I have made a function in my Excel workbook, and can select it from the Insert - Function - User Defined list. When you select it, the dialog box comes up in which you can enter the parameters. When you select a regular function, there is help on each input and a description. Example: VLookup Dialog box has Lookup_value Table_array Col_index_num Range_lookup Below these is a description of the function, "Searches for a value in the leftmost column of a table, and then..." and a description of the current input. Lookup_value for example reads: "Lookup_value is the value to be found in the first column..." How can I get this on my own function? I hope this makes sense. If not, I can try to explain again. Thanks, Brad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function Properties
I'm looking in a John Walkenback book and he seems to say that it's not
possible. You can add a description to the fuction itself that the user would see before opening the function dialog box. Here are the steps he gives: 1. Activate a worksheet in the workbook that contains the custom fuction 2. Tools Macro Macros (or press Alt+F8) 3. In the Macro Name field, type the function's name (note that the function does not appear in the list of macros, you have to type it) 4. Click the options button 5. In the Description field, type a description for the function 6. Click OK 7. Click Cancel Hope that helps "Brad" wrote: Thanks for taking the time to read my question. I have made a function in my Excel workbook, and can select it from the Insert - Function - User Defined list. When you select it, the dialog box comes up in which you can enter the parameters. When you select a regular function, there is help on each input and a description. Example: VLookup Dialog box has Lookup_value Table_array Col_index_num Range_lookup Below these is a description of the function, "Searches for a value in the leftmost column of a table, and then..." and a description of the current input. Lookup_value for example reads: "Lookup_value is the value to be found in the first column..." How can I get this on my own function? I hope this makes sense. If not, I can try to explain again. Thanks, Brad |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function Properties
Brad
You can add a brief description(not arguments) if you open the VBEditor and ViewObject Browser. Find your UDF and right-click and you can add a comment there. 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 Ballon Tips are not available with Laurent's method. Gord Dibben Excel MVP On Sat, 19 Nov 2005 07:46:03 -0800, JNW wrote: I'm looking in a John Walkenback book and he seems to say that it's not possible. You can add a description to the fuction itself that the user would see before opening the function dialog box. Here are the steps he gives: 1. Activate a worksheet in the workbook that contains the custom fuction 2. Tools Macro Macros (or press Alt+F8) 3. In the Macro Name field, type the function's name (note that the function does not appear in the list of macros, you have to type it) 4. Click the options button 5. In the Description field, type a description for the function 6. Click OK 7. Click Cancel Hope that helps "Brad" wrote: Thanks for taking the time to read my question. I have made a function in my Excel workbook, and can select it from the Insert - Function - User Defined list. When you select it, the dialog box comes up in which you can enter the parameters. When you select a regular function, there is help on each input and a description. Example: VLookup Dialog box has Lookup_value Table_array Col_index_num Range_lookup Below these is a description of the function, "Searches for a value in the leftmost column of a table, and then..." and a description of the current input. Lookup_value for example reads: "Lookup_value is the value to be found in the first column..." How can I get this on my own function? I hope this makes sense. If not, I can try to explain again. Thanks, Brad |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function Properties
Thanks to both of you.
Both tips are very helpful! Have a great day, Brad "Brad" wrote: Thanks for taking the time to read my question. I have made a function in my Excel workbook, and can select it from the Insert - Function - User Defined list. When you select it, the dialog box comes up in which you can enter the parameters. When you select a regular function, there is help on each input and a description. Example: VLookup Dialog box has Lookup_value Table_array Col_index_num Range_lookup Below these is a description of the function, "Searches for a value in the leftmost column of a table, and then..." and a description of the current input. Lookup_value for example reads: "Lookup_value is the value to be found in the first column..." How can I get this on my own function? I hope this makes sense. If not, I can try to explain again. Thanks, Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
User defined function | New Users to Excel | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User defined function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |