How do u add list to a combobox in a userform

Alpacino · Apr 25, 2011

I would like to add a list from worksheet 4 into a combobox in a userform how do I do it please??
Regards
Alan

wigi · Apr 25, 2011

For instance, if the combobox is called ComboBox1:

Code:

ComboBox1.List = Sheets(4).Range("A1:A10").Value

and you want cells A1:A10 into the combobox.

VoG · Apr 25, 2011

Try like this in the userform's code module

Code:

Private Sub UserForm_Initialize()
ComboBox1.RowSource = Sheets("Sheet4").Range("A1:A5").Address(external:=True)
End Sub