On Wed, 16 Mar 2005 14:25:56 -0000, "Andibevan"
wrote:

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


1. 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've not tried it out,
however.
--ron