I have a combo box called ComboBox1 on a worksheet. I want to populate
its values in VBA code.

Let's say my list of values is in J2:J12.



I then issue this command: ComboBox1.ListFillRange = "J2:J12", I get
a "Run-time error '424'; Object required" message


If I change this to: Set Worksheets(1).ComboBox1.ListFillRange =
"J2:J12", I get "Run-time error '438'; Object doesn't support this
property or method."



Tried several other combinations, but nothing works yet.

Can anyone help? Thanks.



Dennis Hancy
Eaton Corporation
Cleveland, OH