Defining Categories for Custom Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple User Defined Categories in Insert Function Form 2
How to call user defined function (UDF) from custom menu in Excel2003? 3
How do I add a function category 1
How to assign a Category to a custom function? 5
EXcel Functions in VBA 5
How do I add to the list of function categories? 2
Add-in - add a custom function to a custom group. 1
Having User Defined functions in their own Insert Function category? 1

Back
Top