In another language I am more familiar with than VBA, there is an object
called a picklist. The picklist has multiple columns of data and each column
of data is "sortable" so that when you start typing the entire list, sorted
by that attribute, will be displayed. Also, there are titles on the picklist
and a parameter that allows one or more items to be selected. When the
selection is made the data is then entered in the field where the list was
popped up. If multiple items are selected, the picklist merely "holds" the
results in a array that can then be read in to determine which records were
selected.