An Array to hold Arrays?

I've been playing around with the Add-Ins tab lately and am looking at improving loops when adding Popup controls.

Each popup control has a number of macros linked to it (as Control buttons) and the names of these macros are recorded in a variant array.

Please Login or Register  to view this content.

Now when adding these popups to the Add-Ins tab, I need to repeat the code for every popup instance which is messy and inefficient. I was wondering:

1. whether a "parent" array could be used to hold all the popup arrays declared in the procedure?
2. If yes to above, can it be worked so that I don't need to define the names/number of the popup arrays when adding to the parent array?
3. How can I loop through the parent array to repeat the add ControlButtons code for each Popup array inside the parent array?
4. Am I on the wrong track and should be looking at Collections instead (which I know next to nothing about)?

Why not:
1. Use a table driven approach? (plenty of examples out there)
2. Use the Ribbon properly? (can still incorporate point 1)

Edit: didn't notice who the asker was. New answer: yes, you can have an array of arrays.

Good to hear from you again Romperstomper!

Yes I know that nested arrays can be done however I am struggling to work this into the add-in without repeating all the "add controls" code for each array - I would prefer to loop to add the controls to each popup and also have it flexible enough to quickly and easily add another popup array without having to code a change in size to the "parent" array

I agree that a custom tab on a Ribbon is a much better approach. However I'm curious as to how much you can push the limits of Add-Ins without resorting to a custom tab.

Thanks Kyle. See attached dummy workbook. It's kept in the format of XLSM as it's easier for testing

I tried adding the arrays as

Please Login or Register  to view this content.

but it didn't work.

It doesn't have to be an Add-In. Say you have a Form and you wish to assign X number of Lists to it. The same principle applies.

I can't think of how to use a nested array of 1D arrays without hardcoding the name of each 1D array into the nested array. More importantly, how do I get the loop to work on adding the controls/lists for each array in the nest?

I have come up with a "near enough" solution.

I created a private variant function containing the arrays I want to add. I then set the function as an array of all these arrays (not what I was hoping for, because it means that if I want to add a new array, I need to not only hard code the new array name as a new Dim, I need to add another name to the Nested array)

In the create controls code, I loop through each array in the Nested array. I set a temporary variant as the current array in the nest and then run a secondary loop through the temp array to add the controls. See code at bottom of this post.

In answer to my original questions:

1. Yes (nested array as variant function)
2. Apparently not (or if there is, nobody is saying! )
3. Yes - see code in this post
4. Collections not needed after all

Please Login or Register  to view this content.