vba function description visible in Formula palette ?
 

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

vba function description visible in Formula palette ?
 

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.
--
Regards,
Tom Ogilvy


"Eric H" wrote in message
...
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

vba function description visible in Formula palette ?
 

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/