ComboBox AddItem code to reference cells in a Range
 

I have a range of cells named 'Production_Years' representing the production
years 2009 down to 2000 in cells A1:A10. Each product has ComboBox in which I
would like its particular production years to be populated, i.e. Widget 1's
production years were 2004-2007, so I need to use code such that it pulls the
appropriate years from the 'Production_Years' range to set the ListFillRange
of ComboBox1.

Widget 2's ComboBox2 will have a different range of years but will still
need to pull them from the 'Production_Years' range.

I think I should be using AddItem code and somehow referencing the Index of
the appropriate line in the range. To simplify the fill process I have a
Command Button labeled 'Fill' in which all the code is contained such that
each ComboBox will be appropriately filled when it is clicked.

It is proving to be a difficult problem - for me at least.