Searching Spreadsheet Based on Listbox Information

In my code below i have a loop that searches through my database for The First and Last Name of a selected person in the list box and determines that the person selected in a list box is actually the person in the worksheet.

My question is when i get large amounts of data into the spreadsheet will this loop greatly slow excel down. Is there a better way to link a list box to the worksheet??

Column "A" = First Name
Column "B" = Last Name
"X" - returns row number of person

Please Login or Register  to view this content.

Perhaps using an autofilter and an If statement to catch if the filter matched anything..

So instead of your loop, you could try

Please Login or Register  to view this content.

Thanks For the Response Deamo.

Not quite what i was looking for, not a fan of using autofilter, do you know if i could find the row using ".find()"

example:

Please Login or Register  to view this content.

except have a second criteria within find() using my last name value below

Please Login or Register  to view this content.

Any Ideas Guys?

Regards.

Find may work, i think you'd still need a loop - in cases of finding the firstname, and the lastname doesn't match

To catch your second name you could try something like

I'll have a play and see what i can get working

Please Login or Register  to view this content.

Here's a find with a loop

Please Login or Register  to view this content.