How do you show UDF parameters while typing in formula in Excel?
 

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

How do you show UDF parameters while typing in formula in Excel?
 

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