Forms Control or ActiveX combo box

  • Thread starter Thread starter Jim A
  • Start date Start date
J

Jim A

Hi -
I would like my combo box (either Forms Control or ActiveX) list to change
base on the value of A1.
That is, I have its input range being B1:F1 - "Year 1", " Year 2" etc.
Example:
-If cell A1 is the value "10" then the combo box default list item would be
"Year 1" (which is cell "B1")
-If cell A1 is the value "20" then the combo box default list item would be
"Year 2" (which is cell "C1") ETC...

Any help appreciated - Thanks - Jim A
 
Back
Top