ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding help to a user defined function (https://www.excelbanter.com/excel-programming/403715-adding-help-user-defined-function.html)

Diarmuid

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

GTVT06

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.

Diarmuid

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.



All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com