Trips,Trick and Traps: Excel Form Control ListBox/ComboBox

Trips,Trick and Traps: Excel Form Control ListBox/ComboBox

Questions:

1. How to load a ComboBox/ListBox  from an Array
2. How to load a multi-column ComboBox/ListBox?
3. Get the selected entry in a ComboBox/ListBox?
4. Allow the user to make multiple selections in a ListBox?
5. Load values from a range into a ComboBox/ListBox?
6. Select or de-select all the entries in a multi-selectable ListBox?
7. How to load a ComboBox/ListBox  one entry at a time from a source – e.g an array or ADO.Recordset?
8. How to sort the contents of ComboBox/ListBox?
9. Conditionally enable/disable other controls when the user scrolls through the entries in a ComboBox/ListBox?
10. Count the number of entries in a ComboBox/ListBox?

Answers