Adding items to a Combo Box

Question

I am very new with VBA... How should a add items to a combo box using codes?

Answer 1

Depend of where you want to add this ActiveX object. On sheet

or in VBA form as control

That is collection so 4 example in form as a loop from range:

Private Sub UserForm_Initialize()   
Dim x As Integer  
ComboBox1.Style = fmStyleDropDownList  
For x = 1 To 7   
 ComboBox1.AddItem Cells(x, "a")   
Next   
ComboBox1.ListIndex = 0  
End Sub