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.