Forgot about this as well:-

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

This comment will be shown in the Function Wizard when you click on your
UDF.

i.e. Click on ShowFormula in UDF category and see this.......

ShowFormula(Cell)

Returns the formula of a cell as Text.
Usage is: =ShowFormula(cellref)

"Andibevan" wrote in message
...
Hi There,

I have also searched, looking for a solution to this. I started by
looking
at Microsofts Statistical add-in but this talks to an XLL file which I
can't
open yet. By looking at the APVBAEN.xla file there is nothing I can see
which effects the help text.

1. One obvious solution is to try to make the argument names explanatory.
In other words, instead of

Function foo(a,b,c,d,optional e)

Do something like:

Function foo(StartDate, EndDate, WeekendDay1, WeekendDay2, optional
Holidays)

2. You could look at Longre's FUNCUSTOMIZE.DLL (at
http://xcell05.free.fr/)
which puports to add more involved descriptions. I have only taken a
brief
look at this but It is a good starting point. It took me quite a while to
find as I couldn't get any joy out of google.

Bonne Chance,

Andi



"SRB" wrote in message
...
I would like to add descriptions to user-defined function arguments
similar
to "Rate is the interest rate ...." in the FV function. I would also
like
to
create seperate categories for my functions instead of using the default
"User Defined" category in the insert function dialog. How can I add
"Help
on this function" for the user-function I have created.