The following example uses a range of worksheet cells in a ListBox and, when the user selects a row from the list, displays the row index in another worksheet cell. This code sample uses the RowSource ...

For example, to display rows of data in a list box from a query named CustomerList, set the list box's RowSourceType property to Table/Query and its RowSource property to the query named CustomerList.

In a VBA UserForm, you might want to do more than just display items; you may want to change the contents of a ListBox in real-time based on user actions. For example, like a shopping cart, adding or ...