View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
youngman youngman is offline
external usenet poster
 
Posts: 24
Default how to make self-made vba function easily understood.

thanks a lot
best regards
-------------
"Tom Ogilvy" wrote in 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