M
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.
is created in Visual Basic in an Excel file.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
J
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
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
S
Sam Wilson
I did not know the Ctrl + Shift + A! Good tip...
Jacob Skaria said: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