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.

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" <(E-Mail Removed)> wrote in message
news:df0298af-5b05-4587-872b-(E-Mail Removed)...
>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.

Check out the below..

http://www.jkp-ads.com/articles/RegisterUDF00.as
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.
> .
>

On May 5, 10:36*am, Jacob Skaria
<JacobSka...@discussions.microsoft.com> 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.