Create a help hint for a UDF

[Mary]

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

 

[Jacob Skaria]

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]

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

--From VBE>press F2 Object Browser
--From librariees select VBAproject>From classes select the module which
contain the UDF and from members select the UDF
--Right click the UDF>properties>enter 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

 

[Sam Wilson]

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

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