Searching rows

[masanovic]

Ive used Access to search a table and display results on a form but can this be done in excel? For example, I want the end user to be able to enter "first name" into a text box, and "Surname" into another. I want the rows in excel to be searched and if they match the input to display that row in another form.

Is this possible?

 

[SkipVought]

Hi,

Have you used Edit > Find with your macro recorder?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[masanovic]

I want the user to imput into text boxes and click a command button "search", and the matching row/s to be diaplayed in text boxes on a form, like records.

 

[SkipVought]

That's fine.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}