Adding items to a ComboBox in Excel VBA

[Glenn Speed]

I would like to be able to dynamically add new items to a combobox
using the contents of cells in the spreadsheet. for example, C3..C6
contain the info to be added to the combobox. Can someone tell me the
code to accoplish this. I am familiar with the ComboBox.AddItem
property, but I would like to populate the combobox directly from the
spreadsheet.

Thanks in advance to anyone.

 

[papou]

Hello Glenn
For i = 1 to 6
Combobox1.additem(worksheets("Sheet1").cells(i,3).Value
Next i

HTH
Cordially
Pascal