Displaying the arguments of UDF in the spertip
 

I was searching for a way to have a my custom UDF (may be in an addin)
arguments be displayed in the supertip similar to the way like all
other usual/normal excel functions show.
Also, I want to have my udf listed in the
application.worksheetfunction in the VBA editor.
Any tips will be appreciated.
Thanks in advance.

Displaying the arguments of UDF in the spertip
 

Like;

Application.MacroOptions Macro:="L_VLOOKAllSheets", _
Description:="Performs VLOOKUP across all Worksheets and stops at the
1st match" _
& vbNewLine & "E.G: =L_VLOOKAllSheets(Dog,$C$1:$E$20,2,FALSE)",
Category:="Ozgrid Functions"



--
Regards
Dave Hawley
www.ozgrid.com
"Subodh" wrote in message
...
I was searching for a way to have a my custom UDF (may be in an addin)
arguments be displayed in the supertip similar to the way like all
other usual/normal excel functions show.
Also, I want to have my udf listed in the
application.worksheetfunction in the VBA editor.
Any tips will be appreciated.
Thanks in advance.

Displaying the arguments of UDF in the spertip
 

Check out the below..

http://www.jkp-ads.com/articles/RegisterUDF00.asp
http://www.dailydoseofexcel.com/arch...on-with-excel/


I hope you already know the option of displaying the arguments on hitting
Ctrl+Shift+A soon after you enter the function name

--
Jacob (MVP - Excel)


"Subodh" wrote:

I was searching for a way to have a my custom UDF (may be in an addin)
arguments be displayed in the supertip similar to the way like all
other usual/normal excel functions show.
Also, I want to have my udf listed in the
application.worksheetfunction in the VBA editor.
Any tips will be appreciated.
Thanks in advance.
.

Displaying the arguments of UDF in the spertip
 

On May 5, 10:36*am, Jacob Skaria
wrote:
Check out the below..

http://www.jkp-ads.com/articles/Regi...istering-a-use...

I hope you already know the option of displaying the arguments on hitting
Ctrl+Shift+A soon after you enter the function name

--
Jacob (MVP - Excel)



"Subodh" wrote:
I was searching for a way to have a my custom UDF (may be in an addin)
arguments be displayed in the supertip similar to the way like all
other usual/normal excel functions show.
Also, I want to have my udf listed in the
application.worksheetfunction in the VBA editor.
Any tips will be appreciated.
Thanks in advance.
.- Hide quoted text -

- Show quoted text -

Jacob
I checked up your links
But, the links are good to show a method for getting the name of the
function easily listed
and also the function names are displayed as you start typing their
names
However, I want to make the arguments be shown automatically
For example, to make clear what i want
On pressing =sum( excel automatically shows Sum(Number1,
[Number2],...) to help the user on the arguments
So, I want my custom function also show the same.
Thanks for your reply to may question and the response.