When you type in an Excel formula such as "=IF(......)" into a cell in Excel,
it shows you a tooltip text with the paremeters of the formula just like VBA
does or C# does in Visual Studio, etc.

I have created several UDFs in an XLA. When I type the name of my UDF into
a cell (for example "=MyUDF(........)") I would like to be able to display
the same type of tooltip text with my parameters. Is this possible?

Thanks,
Jeff

Hello

Have a look here and follow the linked websites:

http://www.dailydoseofexcel.com/arch...on-with-excel/

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"J. Caplan" wrote:

> When you type in an Excel formula such as "=IF(......)" into a cell in Excel,
> it shows you a tooltip text with the paremeters of the formula just like VBA
> does or C# does in Visual Studio, etc.
>
> I have created several UDFs in an XLA. When I type the name of my UDF into
> a cell (for example "=MyUDF(........)") I would like to be able to display
> the same type of tooltip text with my parameters. Is this possible?
>
> Thanks,
> Jeff
>