How to add items to a combobox in a form in excel VBA?

Solution 1:

The method I prefer assigns an array of data to the combobox. Click on the body of your userform and change the "Click" event to "Initialize". Now the combobox will fill upon the initializing of the userform. I hope this helps.

Sub UserForm_Initialize()
  ComboBox1.List = Array("1001", "1002", "1003", "1004", "1005", "1006", "1007", "1008", "1009", "1010")
End Sub

Solution 2:

Here is another answer:

With DinnerComboBox
.AddItem "Italian"
.AddItem "Chinese"
.AddItem "Frites and Meat"
End With

Source: Show the

Solution 3:

I found this;

Excel VBA ComboBox Lists

from here;

vba- Can a combobox present more then one column on it's textbox part?

and this may help;

Populating ComboBoxes VBA

I added a sort of demo here;

Playing with populating boxes.xlsm

How to add items to a combobox in a form in excel VBA?

Solution 1:

Solution 2:

Solution 3:

Related

Recent Posts