View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_2_] Andibevan[_2_] is offline
external usenet poster
 
Posts: 128
Default Excel user-defined functions.

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.