VBA - Adding Items to a combobox* 15/03/2002
To populate a combobox or a listbox is the same. You could add from the code or even from a range of cells in your spreadsheet. To add from the code, just add this line to your code.
ComboBox1.AddItem "Product A"
ComboBox1.AddItem "Product B"