Using text boxes and command buttons to search

[Lee Stokes]

hi i am using excel 2000, i have a few columns but the main ones are:

Christian Name Surname Employee Number

i want to have a text box or combo box at the sheet for each serach,
they will only be, Surname and employee number, when i typ in for
example bloggs into the surname text box and click the command button
"next" i want it to find every entry in the surname column matching
the word bloggs, and the same with employee number? but i have no idea
how? i have created the text box and button but dont know what to do
with them? is this the best way? this is how i have seen it be done?

HEEEELPPPPP!!!!

 

[Dave Peterson]

If you change your requirements slightly, you might be able to use Jan Karel
Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/

It's very close to what you want--maybe sufficiently close????