My ActiveX combo box/drop-down menu will not populate with a dynamic named range that refers to values going horizontally (e.g., A2, B2, C2...). The first value, in cell A2 populates in the drop-down, but the remainder values (B2, C2...) will not populate.
I have tried to declare the horizontal list using the following formulae:
=OFFSET($A$2,0,0,1,COUNTA(2:2))
and
=$A$2:INDEX($2:$2,COUNTA($2:$2))
I don't see why either wouldn't work, but perhaps there's something funky with how the ActiveX combo box performs. Any help would be appreciated, thank you.
I have tried to declare the horizontal list using the following formulae:
=OFFSET($A$2,0,0,1,COUNTA(2:2))
and
=$A$2:INDEX($2:$2,COUNTA($2:$2))
I don't see why either wouldn't work, but perhaps there's something funky with how the ActiveX combo box performs. Any help would be appreciated, thank you.