Multiple User Defined Categories in Insert Function Form

[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?

 

[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???

 

[JamesMc]

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