What is the difference between ComboBox and ListBox?

/ by

The question here is “what is the difference between combobox and listbox?”

Basically with a combobox you see one selected item at a time, and with a listbox you
can see multiple items, and multiple selected items.

Consider the following 2 examples, where you have a userform with 2 controls displaying the same data listed on a worksheet in the workbook:

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. You normally will only use this box to show 1 item.

Here is the code:

ComboBox

The ComboBox shows only 1 entry despite the fact that there are multiples.

The ComboBox is usually used when there is only 1 item to select.

ListBox

The ListBox shows every item in the list.

The ListBox is usually used if you want to allow multiple selections or you want to show all the options possible to select.

Watch this:

Let me know if you have any questions.

Please remember to subscribe to my youtube channel

Been helped? Get these!

Facebooktwittergoogle_plusredditpinterestlinkedinmail