Hi Tim

You can Filter with the Contains option
AutofilterCustum
or the Begins-Contains-Ends tab in EasyFilter

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tim" wrote in message ...
I think the proble with using a filter is that I need to
search a single word in a sentence. Every line or string
of text is unique.

Ex:

"Shot of girl holding lolipop against a white background."

The user may be looking for one or a few of the words in
the description above.

Thanks again



-----Original Message-----
Or this Add-in
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Norman Jones" wrote
in message ...
Hi Tim,

Look at AutoFilter.

See Debra Dalgleish's autofilter notes at:

http://www.contextures.com/xlautofilter01.html


---
Regards,
Norman



"Tim" wrote in
message ...
Hello All,

I have a work book that contains a flat database
(table). My user would like to type a keyword(s) that
are contained in a particular field and then return a
list of records that contain the keyword(s).

I would like to do this using userforms? maybe a list
box
to show the results. I need help with the code that
will
search the field and return the information. I am
open
to all suggestions.

Thanks in advance




.