Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding help to a user defined function
Hi,
I have created a UDF which I am using in a series of Work Sheets. Is it possible to add help to the function so that when a user selects it from the function wizard the help will be displayed? Regards Diarmuid |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding help to a user defined function
On Jan 5, 11:55*am, Diarmuid
wrote: Hi, I have created a UDF which I am using in a series of Work Sheets. Is it possible to add help to the function so that when a user selects it from the function wizard the help will be displayed? Regards Diarmuid In the workbook press Alt+F8 and in the Macro Name Field type the functions name, then click options, and in the Description field, type a description for the function. then click ok. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding help to a user defined function
Hi,
Unfortunately that wont work as the function wont appear in the macro list. I am relatively new to this so there may be awayb of getting the function to appear in the list. The function itself is written using visual basic. Thanks for the tip though, its good to know that there is a way of adding help to macros. regards Diarmuid "GTVT06" wrote: On Jan 5, 11:55 am, Diarmuid wrote: Hi, I have created a UDF which I am using in a series of Work Sheets. Is it possible to add help to the function so that when a user selects it from the function wizard the help will be displayed? Regards Diarmuid In the workbook press Alt+F8 and in the Macro Name Field type the functions name, then click options, and in the Description field, type a description for the function. then click ok. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
User defined function - adding names | Excel Programming | |||
Adding a pop-up help to a user-defined function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |