ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UDF screentip (https://www.excelbanter.com/excel-programming/292757-udf-screentip.html)

No Name

UDF screentip
 
I have written some custom functions. Because one of them
has five input parameters, I would like to use a screentip
like Excel has for standard functions (that yellow box
that gives you info about input parameters). Is there a
way to create this for a UDF?

Thanks in advance for any help.

Dave


MP Capital Advisory

UDF screentip
 
In excel, go to Tools/Macro and enter the name of your UDF. Go to options
and key-in the help/description.

wrote in message
...
I have written some custom functions. Because one of them
has five input parameters, I would like to use a screentip
like Excel has for standard functions (that yellow box
that gives you info about input parameters). Is there a
way to create this for a UDF?

Thanks in advance for any help.

Dave




No Name

UDF screentip
 
This adds help, but it still doesn't show the yellow
ScreenTip. I am not sure if I am doing something wrong.
It works for the built in functions.

Thanks for the tip on getting the help text.

-----Original Message-----
In excel, go to Tools/Macro and enter the name of your

UDF. Go to options
and key-in the help/description.

wrote in message
...
I have written some custom functions. Because one of

them
has five input parameters, I would like to use a

screentip
like Excel has for standard functions (that yellow box
that gives you info about input parameters). Is there a
way to create this for a UDF?

Thanks in advance for any help.

Dave



.



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

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