View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Shorrock Chris Shorrock is offline
external usenet poster
 
Posts: 2
Default User Defined Function (UDF) Tooltip

Hi, does anyone know if it is possible create custom tooltips for user
defined functions. I am an Engineer developing an Addin with a few common
functions. A simple example of a user defined function would be:

Public Function CircleArea(Diameter as Double) As Double

CircleArea = 3.1414925 * (Diameter ^ 2) / 4

End Function

When Someone types "=CircleArea(" in Excel I want a tooltip to appear and I
am going to use it to help the user know what the units should be, e.g. in
this case meters [m]. It's not really practical to rely on the arguments
when viewed in the function wizard, if it's used!

Many thanks in advance...
Chris Shorrock
Worcester, England.