Create a help hint for a UDF
 

How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file.

Create a help hint for a UDF
 

This is called the tooptip and there is no direct way to create the same for
UDF with Excel VBA...

PS: After typing the =functionname hitting Ctrl+Shift+A will give you the
argument names displayed in the worksheet...()

If this post helps click Yes
---------------
Jacob Skaria


"Mary" wrote:

How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file.

Create a help hint for a UDF
 

Just to add a description to be viewed by the user in the function wizard you
can try the below..

--From VBEpress F2 Object Browser
--From librariees select VBAprojectFrom classes select the module which
contain the UDF and from members select the UDF
--Right click the UDFpropertiesenter description which will be displayed
in the function wizard.

--More here
http://www.jkp-ads.com/articles/RegisterUDF00.asp


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

This is called the tooptip and there is no direct way to create the same for
UDF with Excel VBA...

PS: After typing the =functionname hitting Ctrl+Shift+A will give you the
argument names displayed in the worksheet...()

If this post helps click Yes
---------------
Jacob Skaria


"Mary" wrote:

How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file.

Create a help hint for a UDF
 

I did not know the Ctrl + Shift + A! Good tip...

"Jacob Skaria" wrote:

This is called the tooptip and there is no direct way to create the same for
UDF with Excel VBA...

PS: After typing the =functionname hitting Ctrl+Shift+A will give you the
argument names displayed in the worksheet...()

If this post helps click Yes
---------------
Jacob Skaria


"Mary" wrote:

How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file.