This is a built in capability of the Autofilter found under
Data=Filters=Autofilter.

--
Regards,
Tom Ogilvy


"Greg B" wrote in message
...
How do I get a combo box to show all the matches with the name written in
the combo box?

The names I have will be on column B and the spreadsheet is called
customers

Thanks in advance

Greg