Combo box feed
 

ComboBox1.List = Worksheets("Sheet1").Range("A1:A10").Value

or

ComboBox1.RowSource = "Sheet1!A1:A10"

or

Dim cell As Range
For Each cell In Worksheets("Sheet1").Range("A1:A10")
ComboBox1.AddItem cell.Value
Next cell

For more info on comboboxes/listboxes see www.rubbershoe.com/listbox.htm

Hth
Tim Zych

"igor" wrote in message
...
Hi,

guys i'm haveing a problem feeding a combobox off of a
spredsheet. i have a user form that contains a combo box.
i want it to be fed by items listed on sheet1 in cells a1
thru a10. Please help.

Thanks in advance.