Forms Control or ActiveX combo box

[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

 

[Dave Peterson]

Maybe you could use Data|Validation and use dependent lists.

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

 

[Jim A]

Great site for my needs - thanks - Jim A

Maybe you could use Data|Validation and use dependent lists.

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html