Multiple User Defined Categories in Insert Function Form

J

JamesMc

I've created about ten of user defined functions using VBA in Excel 2007.
When I try to access them from Excel using the Insert Function form and
trying to select the functions by category, the User Defined category appears
ten times in the 'Or select a category' list, one for each function. This
make sit very difficult to select the functions I want to use.

Initially there was only a single User Defined category that contained all
functions, but after I changed one of them I now have the problem. It's the
same whether I store them in the Personal Workbook, another work book, of as
an add-in.

Does anybody know why this has happened and how to fix it?
 
O

ozgrid.com

RE: Initially there was only a single User Defined category that contained
all
functions, but after I changed one of them I now have the problem

What did you change???
 
J

JamesMc

ozgrid.com said:
RE: Initially there was only a single User Defined category that contained
all
functions, but after I changed one of them I now have the problem

What did you change???

I changed several things before testing. I've sorted it out now. The
problem was an invalid data type in one of the functions. Wierd eh?

Thanks anyway Dave
 

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

Top