populate list with combo box code example

Example: excel vba Populating a combobox on a userform from a range of cells

Private Sub UserForm_Initialize()
    ComboBox1.List = [Sheet1!A1:A10].Value
End Sub