Defining Categories for Custom Functions

I have developed several custom functions which are loaded with an add-in.
When I use the Insert Function box my custom functions show up under the User
Defined category. I know that I can assign my functions to one of Excel's
pre-exisitng categories. Its it possbilbe to define my own categories for my
custom functions?

There is a method described by Laurent Longre in the EEE newsletter at
http://j-walk.com/ss/excel/eeeÂ*/eee009.txt

I just tested it and it still works, you just need to make sure that you
have the correct path to user32.dll.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim" <Jim@discussions.microsoft.com> wrote in message
news:DDA145EC-D238-416F-9DBD-E38A63CE7ACC@microsoft.com...
> I have developed several custom functions which are loaded with an add-in.
> When I use the Insert Function box my custom functions show up under the
User
> Defined category. I know that I can assign my functions to one of Excel's
> pre-exisitng categories. Its it possbilbe to define my own categories for
my
> custom functions?

Thanks! This is exactly what I was looking for.

"Bob Phillips" wrote:

> There is a method described by Laurent Longre in the EEE newsletter at
> http://j-walk.com/ss/excel/eeeÂÂ*/eee009.txt
>
> I just tested it and it still works, you just need to make sure that you
> have the correct path to user32.dll.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jim" <Jim@discussions.microsoft.com> wrote in message
> news:DDA145EC-D238-416F-9DBD-E38A63CE7ACC@microsoft.com...
> > I have developed several custom functions which are loaded with an add-in.
> > When I use the Insert Function box my custom functions show up under the
> User
> > Defined category. I know that I can assign my functions to one of Excel's
> > pre-exisitng categories. Its it possbilbe to define my own categories for
> my
> > custom functions?
>
>
>

I cant seem to get this to work or to figure out how to use it. What is the
"Auto_Open" method and how is it called and by what? Is it an event? What are
the arguments to the "REGISTER" API, and what are "CharPrevA" and "CharNextA"
supposed to be? Also, what is the NbArgs argument to the Register method for?

"Jim" wrote:

> Thanks! This is exactly what I was looking for.
>
> "Bob Phillips" wrote:
>
> > There is a method described by Laurent Longre in the EEE newsletter at
> > http://j-walk.com/ss/excel/eeeÂ*/eee009.txt
> >
> > I just tested it and it still works, you just need to make sure that you
> > have the correct path to user32.dll.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Jim" <Jim@discussions.microsoft.com> wrote in message
> > news:DDA145EC-D238-416F-9DBD-E38A63CE7ACC@microsoft.com...
> > > I have developed several custom functions which are loaded with an add-in.
> > > When I use the Insert Function box my custom functions show up under the
> > User
> > > Defined category. I know that I can assign my functions to one of Excel's
> > > pre-exisitng categories. Its it possbilbe to define my own categories for
> > my
> > > custom functions?
> >
> >
> >

Another solution here : http://xcell05.free.fr/english/#FunCustomize

Regards.

Jason Rodman a écrit :
> I cant seem to get this to work or to figure out how to use it. What is the
> "Auto_Open" method and how is it called and by what? Is it an event? What are
> the arguments to the "REGISTER" API, and what are "CharPrevA" and "CharNextA"
> supposed to be? Also, what is the NbArgs argument to the Register method for?
>
> "Jim" wrote:
>
>
>>Thanks! This is exactly what I was looking for.
>>
>>"Bob Phillips" wrote:
>>
>>
>>>There is a method described by Laurent Longre in the EEE newsletter at
>>>http://j-walk.com/ss/excel/eeeÂ*/eee009.txt
>>>
>>>I just tested it and it still works, you just need to make sure that you
>>>have the correct path to user32.dll.
>>>
>>>--
>>>
>>>HTH
>>>
>>>RP
>>>(remove nothere from the email address if mailing direct)
>>>
>>>
>>>"Jim" <Jim@discussions.microsoft.com> wrote in message
>>>news:DDA145EC-D238-416F-9DBD-E38A63CE7ACC@microsoft.com...
>>>
>>>>I have developed several custom functions which are loaded with an add-in.
>>>>When I use the Insert Function box my custom functions show up under the
>>>
>>>User
>>>
>>>>Defined category. I know that I can assign my functions to one of Excel's
>>>>pre-exisitng categories. Its it possbilbe to define my own categories for
>>>
>>>my
>>>
>>>>custom functions?
>>>
>>>
>>>