Help! Adding Description to Custom Functions

[neven802]

How do you add descriptions to custom Excel functions such that while filling in the required fields, the descriptions to the required fields are shown below in a pop up bubble? (as shown in the below image)

<a href="http://s22.photobucket.com/albums/b330/nevenlongboards/?action=view&current=Picture2.jpg" target="_blank"><img src="http://i22.photobucket.com/albums/b330/nevenlongboards/Picture2.jpg" border="0" alt="Photobucket"></a>


Thanks!!

Warrick

 

[xld]

Use the MacroOptions property of the Application object

Application.MacroOptions Macro:="FunctionName", Description:="Text to show"

 

[xld]

Oh you want argument descriptions.

Get hold of Laurent Longre DLL at http://longre.free.fr/english/func_cats.htm

 

[Kenneth Hobson]

Welcome to the forum!

I have not seen how to do what he wants Bob.

The first method that Bob posted is usually sufficient for my needs. Some like to use the features that Bob's 2nd reference demonstrates.