View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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