{"id":300,"date":"2019-01-12T17:45:26","date_gmt":"2019-01-12T17:45:26","guid":{"rendered":"http:\/\/www.vbastring.com\/blog\/?p=300"},"modified":"2019-01-12T18:30:10","modified_gmt":"2019-01-12T18:30:10","slug":"what-is-the-difference-between-combobox-and-listbox","status":"publish","type":"post","link":"https:\/\/vbastring.com\/blog\/2019\/01\/12\/what-is-the-difference-between-combobox-and-listbox\/","title":{"rendered":"What is the difference between ComboBox and ListBox?"},"content":{"rendered":"

The question here is “what is the difference between combobox and listbox?”<\/p>\n

Basically with a combobox you see one selected item at a time, and with a listbox you
\ncan see multiple items, and multiple selected items.<\/p>\n

Consider the following 2 examples, where you have a userform with 2 controls displaying the same data listed on a worksheet in the workbook:<\/p>\n

\"\"<\/a><\/p>\n

Both options show data from the same worksheet. No matter how tall you make the combobox on the left, it is still going to only display 1 item.<\/strong> You normally will only use this box to show 1 item.<\/p>\n

Here is the code:<\/p>\n

Private Sub UserForm_Initialize()\r\n    LoadBoxes\r\nEnd Sub\r\n\r\n\r\nSub LoadBoxes()\r\n    Dim intCounter As Integer\r\n    \r\n    'load combobox\r\n    With Me.cboSuppliers\r\n        .Clear\r\n        For intCounter = 1 To 132\r\n            .AddItem Sheets(\"Suppliers\").Cells(intCounter, 1).Value\r\n        Next intCounter\r\n    End With\r\n    \r\n    'load listbox\r\n    With Me.lstSuppliers\r\n        .Clear\r\n        For intCounter = 1 To 132\r\n            .AddItem Sheets(\"Suppliers\").Cells(intCounter, 1).Value\r\n        Next intCounter\r\n    End With\r\nEnd Sub\r\n<\/pre>\n
ComboBox<\/h2>\n
The ComboBox shows only 1 entry despite the fact that there are multiples.<\/p>\n
The ComboBox is usually used when there is only 1 item to select.<\/p>\n
ListBox<\/h2>\n
The ListBox shows every item in the list.<\/p>\n
The ListBox is usually used if you want to allow multiple selections or you want to show all the options possible to select.<\/p>\n
Watch this:<\/p>\n