Eric H wrote:
*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 *

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


--------------------



---
Message posted from http://www.ExcelForum.com/