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.

    Dim varPopup1MacroNames() As Variant
    Dim varPopup2MacroNames() As Variant
    Dim varPopup3MacroNames() As Variant
    Dim varPopup4MacroNames() As Variant
    Dim varPopup5MacroNames() As Variant
    Dim varPopup6MacroNames() As Variant
    Dim varPopup7MacroNames() As Variant

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

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

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.

I tried adding the arrays as

varPopupMacroNames(1)

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

        For bytArrNo = LBound(varPopupMacroNames) To UBound(varPopupMacroNames)
            varTemp = varPopupMacroNames(bytArrNo)
            With .Add(Type:=msoControlPopup, temporary:=True)
                .Caption = varTemp(1)
                .BeginGroup = True
                .Tag = C_TAG
                For bytCtrl = LBound(varTemp) + 1 To UBound(varTemp)
                    With .Controls.Add(Type:=msoControlButton, temporary:=True)
                        .OnAction = "'" & ThisWorkbook.Name & "'!" & varTemp(bytCtrl)
                        .Caption = varTemp(bytCtrl)
                        .Tag = C_TAG
                    End With
                Next bytCtrl
            End With
        Next bytArrNo