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

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

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



.