Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function same description but different result | Excel Worksheet Functions | |||
Function parameter description | Excel Programming | |||
access function description from c | Excel Programming | |||
access function description from c++ | Excel Programming | |||
access the function description | Excel Programming |