Why not just use Filters instead. Data - Filter - AutoFilter... See if that
is close to what you want.

--
HTH...

Jim Thomlinson


" wrote:

In an Excel sheet I have an employee list (Last name, First name, id#,
paylist...)
I've need to create some kind of search box so that one can type in
the last name, first name, or ID and will get a list of all criteria
that matches.

My table starts at B3 (last name) and ends at F3000

Does someone know how to do something like that or where I can find
macro code for such a search function? Or could I create a Text box
that
would do the search for me?

Any help is very appreciated

Mel