vba function description visible in Formula palette ?

  • Thread starter Thread starter Eric H
  • Start date Start date
E

Eric H

I can't create a description for the vba function and its arguments, which
should be seen in the formula palette while browsing the functions of the
..xla.
Does anyone knows how to add these kind of comments ?
Thanks from advance
 
Adding arugment descriptions isn't really supported. For the functions
themselves, you can use the object brower in the VBE to look at the xla,
then select your function and right click on it and select properties.
Enter your description there.


You can look at Laurent Longre's pages on this topic:


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

http://longre.free.fr/english/index.html#FunCustomize

the second article is really just a download and offers a DLL you can use to
add arguments descriptions I believe.
 
Eric said:
*I can't create a description for the vba function and its arguments,
which
should be seen in the formula palette while browsing the functions of
the
..xla.
Does anyone knows how to add these kind of comments ?
Thanks from advance *
Click to expand...

Hello Eric,

Search "MacroOptions" by VBA help please.
You can add comments as follows.


Code:
--------------------

Function Example() As String
Example = "Hi There!"
End Function

Sub Add()
Application.MacroOptions Macro:="Example", _
Description:="Write comment here."
End Sub


--------------------
 
Back
Top