Add the following to the Workbook_Open() sub of the work
book containing the UDF

Application.MacroOptions Macro:="FName", _
Description:="Returns whatever..."

Where FName is the name of the function (incl quotes).

Comment: This is best done with an AddIn file (.xla).

Hope this helps,

Tony

-----Original Message-----
Hi All,

Does anyone have any pointers or ideas on how you can add
help text to a
user defined function.

I.e. When you select IF from the functions menu it
says "Returns one value
if a condition you specify evaluates to TRUE and another
value if it
evaluates to FALSE"

There is also help text on the individual formula
components of the
Microsoft functions.

I have created a number of user functions and they would
be a lot better if
they were clearer and more user friendly.

Any pointers or ideas of where to look would be gladly
received.

Ta

Andi


.