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
Private Sub UserForm_Initialize()
ComboBox1.List = [Sheet1!A1:A10].Value
End Sub