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