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.

Yes?

"Mike H." wrote:

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.

thanks for sharing.

If there was a question, you didn't state it. If you wondered if there was
a similar control shipped with Office, no.

If you know the name of your control, in the VBE, go to more controls and
see if that control can be selected from the list. If so, try putting it on
a userform and seeing if it will work. However, if you want to distribute
this workbook, you would need to make sure the computers using the file had a
registered version of that control (or have the authority to distribute it,
then install it).

--
Regards,
Tom Ogilvy


"Mike H." wrote:

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.

Sorry, my question needs the old Jeopardy response Alex Trebec says, "Please
state In the form of a question"... I was wondering if there is a similar
control in VBA and if so, what is it?