Just to clarify Bruce's statement in contrast to my advice: That puts in a
description of the function, but not text for the arugments (the question
asked as I understood it).


--
Regards,
Tom Ogilvy

"bruce taylor" wrote in message
...
Someone has found a way of putting a helpfull paragraph
in the function wizard dialog box.

Open vba development window, place cursor inside your
UDF, press F2. This opens the object explorer.

Select your project from the list of libraries, right
click on your UDF (in the RH pane) and select properties.
Type your paragraph here.
-----Original Message-----
VBA functions don't support text descriptions in the
Function wizard.

You can look at the information Laurent Longre has
posted on his site about
this:

http://longre.free.fr/english/func_cats.htm

Newer addin that supports this:
http://longre.free.fr/english/index.html#FunCustomize

--
Regards,
Tom Ogilvy


"youngman" wrote in message
...
hi,

i am making some funcyions in excel vba ,when the fun
is complicated it
is
diffcult to recognize the meaning when i use the
function.


for instance
Function CalculateSquareRoot(NumberArg As Double) As
Double
If NumberArg < 0 Then
Exit Function '
Else
CalculateSquareRoot = Sqr(NumberArg)
End If
End Function

i mean how to make the meaning of NumberArg be easily
recognized.
how to make a hint about the fun.

thank you





.