What is the syntax to populate a combo box?

'method 1
With <combobox name>
     .AddItem “<option 1>     .AddItem “<option 2>      End With

'method 2 - populate from a range
<combobox name>.List = Sheets("<sheet name containing range>").Range("<range index>").Value
Advertisements