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

Question

I am new to VBA  I want to create a form where a user selects an item of a combobox and the selection runs a macro I created a user form in VBA but I am unable to add items to the Combobox When a user opens the form I want the choices in the combobox to be already loaded how can I accomplish this   Thank You

User · Accepted Answer

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

User · Answer

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

User · Answer

Here is another answer   With DinnerComboBox  AddItem  Italian   AddItem  Chinese   AddItem  Frites and Meat  End With    Source  Show the

[vba] How to add items to a combobox in a form in excel VBA?

Examples related to vba

Examples related to excel

Examples related to combobox