when in the IDE, open the Object Browser ( F2) select the VBA Project from
the object dropdown and you will see the function listed under members. If
not, select the correct class until you see the function appear in Members.
Right cklick the function, select Properties and edit the Description. This
will appear in the sheet in one uses the formula button.

There probably to add a tool tip - but I've not come accross it outside of
using C++



"Chris Shorrock" wrote:

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.