View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default 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