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

by

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

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. VBA code required for Msg Box when two value equal in two cells
  4. Excel VBA deleting rows in a for loop misses rows
  5. How To Speed Up VBA Code
  6. What is the lifetime of a global variable in excel vba?
  7. Download attachment from Outlook and Open in Excel
  8. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  9. Embed picture in outlook mail body excel vba
  10. How to check for empty array in vba macro [duplicate]
  11. Use autofilter on more than 2 criteria
  12. What is the function of FormulaR1C1?
  13. Compiler Error: User-defined types not defined
  14. Open a workbook using FileDialog and manipulate it in Excel VBA
  15. Vba Excel do vlookup from a closed file
  16. excel hyperlink to nothing
  17. How to add headers to a multicolumn listbox in an Excel userform using VBA
  18. How to send files via HTTP_POST with Excel using VBA?
  19. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  20. How to Add Date Picker To VBA UserForm
  21. Vba macro to copy row from table if value in table meets condition
  22. How to create dynamic variable names VBA
  23. How to break a long string into multiple lines
  24. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  25. simple vba code gives me run time error 91 object variable or with block not set
  26. How do I open a file if I only know part of the file name?
  27. VBA recognizing workbook by partial name
  28. VBA inheritance, analog of super
  29. Open Google Chrome from VBA/Excel
  30. Excel VBA Run-time error 1004 when inserting or value formula into cell

Leave a Comment