vba listbox multicolumn add [duplicate]

by

Simplified example (with counter): 

With Me.lstbox
    .ColumnCount = 2
    .ColumnWidths = "60;60"
    .AddItem
    .List(i, 0) = Company_ID
    .List(i, 1) = Company_name 
    i = i + 1

end with

Make sure to start the counter with 0, not 1 to fill up a listbox.

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. Get list of sub-directories in VBA
  4. So, I have 6 “master” files to then divide into 40 separate files
  5. Application.Match gives type mismatch
  6. What does the Call keyword do in VB6?
  7. Count and Highlight keywords within phrases
  8. Protecting cells in Excel but allow these to be modified by VBA script
  9. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  10. How to securely store Connection String details in VBA
  11. How to type Unicode currency character in Visual Basic Editor
  12. Detect merged cells in VBA Excel with MergeArea
  13. Hash Table/Associative Array in VBA
  14. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  15. Parse HTML content in VBA
  16. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  17. How do I name a spreadsheet automatically, by referencing two cells?
  18. Excel VBA Delete Rows
  19. Is “Value” actually the default property of the Range object?
  20. VBA – how to conditionally skip a for loop iteration
  21. VBA: How to delete filtered rows in Excel?
  22. VBA.Find and adding a value
  23. How to continue the code on the next line in VBA
  24. Excel VBA Userform – Execute Sub when something changes
  25. What is behind this difference in parentheses effect in VBA?
  26. Getting Excel to refresh data on sheet from within VBA
  27. Finding first blank row, then writing to it
  28. Does the bitness of the OS ever matter, or is it just the application I need to worry about?
  29. Where does Outlook store the VBA code files?
  30. To find and replace a text in the whole document in MS Word 2010 (including tables)

Leave a Comment