When I open an Excel function(e.g. IF function), message box that contains
the function arguments shows a description of the function as well as a
dscription of current variable selected. When I set the cursor into the next
variable, the description of this variable is shown.

How can I use this functionality in my own VBA functions?

FYI: I am particularly looking for a way to define description text in
relation to the variables. I have managed to change the overall description
text (i.e. of the function).

I am using Excel 2007

To customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

Ballon(Tool) Tips are not available with Laurent's method.

I don't know if the add-in will work with 2007 and I cannot test since I
don't have 2007 installed.


Gord Dibben Excel MVP

On Wed, 21 Jan 2009 17:39:53 +0100, "Mike" wrote:

When I open an Excel function(e.g. IF function), message box that contains
the function arguments shows a description of the function as well as a
dscription of current variable selected. When I set the cursor into the next
variable, the description of this variable is shown.

How can I use this functionality in my own VBA functions?

FYI: I am particularly looking for a way to define description text in
relation to the variables. I have managed to change the overall description
text (i.e. of the function).

I am using Excel 2007