My application has a listbox whose data contains entries like to the following:

Groceries - Food
Groceries - Paper Items
Groceries - Health and Hygiene
Office Supplies - Paper Items
Party Supplies - Paper Items
Dinnerware - Paper


If the user is not familiar with the structure of these categories, they
might try browsing the list for "food" or "pape" or "heal", instead of going
for "groc", and think that there is no category defined for the particular
item they are interested in.
Upon not finding any items that start with these character strings, the user
would be faced with browsing the entire list.

I'd like to provide the ability to search the list on specific words or
strings other than the first characters of the entry. For example, the user
might want to look for "paper" or "paper items" and get back a list showing:

Groceries - Paper Items
Office Supplies - Paper Items
Party Supplies - Paper Items
Dinnerware - Paper
etc.

By clicking one of the items in this subset of the listbox items, the
process would then behave as if the user had clicked on the item from the
listbox.

Could someone suggest an approach to implementing such a capability? I want
the user NOT to have to things that require excel-specific knowledge such as
"click find, then copy the full text of the entry, then go back to the user
form and paste it into the listbox...". In other words, I'd like the user
only to have to click command button on the user form and be prompted for the
seach parameter and then be returned to the user form with a famliar "choose
one of the entries" type of control such as another listbox.

TIA,
Phil