=AVERAGEIFS(MFI,DATE,">="&JanStart,DATE,"<="&JanEnd)

MFI is the named ranged that is referencing a column of data. This works, but I want to be able to change the MFI to a different named ranged.

So what I am trying to do is using an ActiveX Combo box so I can reference the named ranges that I have set, for example MFI, so each time a user chooses MFI or another named range, it will output to a linked cell (A1). Then the linked cell will be referenced into this forumla.

=AVERAGEIFS(A1,DATE,">="&JanStart,DATE,"<="&JanEnd)

Is it possible for A1 to be linked to the named range, so if the user choses MFI in the combo box, it will change all AverageIFS formulas to look at a different named range.