Excel Userform Searching Multiple Criteria

[Typographics]

This is either the easiest problem to solve, or the hardest, as I've spent hours trying to look this up.

I have a worksheet populated with about 15,000 rows and 8 columns full of data. I have created a simple userform to quickly search the list, however, I need the ability to search two fields at the same time. I want to find the row with a specific Vendor Code and Document Type. There should only be one result if both criteria are searched simultaneously.

Capture.PNG

My current code for the Find Data button is below. As you can see, I'm only searching for the Vendor Code.

Please Login or Register  to view this content.

If anyone could help me that would be amazing. Thank you.

[Marc L]

See in the VBA inner help the sample of the Range.Find method as you can use for the first field.
Once the field found, check the second field on the same row …

[Typographics]

Thanks for your reply Marc. Assume I have a limited knowledge of VBA. What would the code look like for what you're talking about? I looked at different Range methods and nothing looked like what I need.

[dotchiejack]

Does this help you?
Data that does not match the search criteria disappears from the list.
See attached.

[Marc L]

What would the code look like for what you're talking about?

It exactly looks like the Range.Find sample in the VBA help !

[torachan]

Does this approach fit your needs.
The comboboxes only load with unique(not repeated) items actually from your database.
Paste your data into the sheet (it should automatically accommodate expansion).
Upto 200,000 rows the search is virtually instant.
torachan.

[Typographics]

dotchiejack,

Thank you so much for helping me. The search function doesn't work for what I need. When I search a Vendor Code and Document type, I only want the rows where those two match. Right now, it gives me everything with a Vendor Code of "X" and Document Type of "Y". In the example below, the highlighted entries are the only ones I want displayed when I search for both variables:

Attachment 628012

Everything else works perfectly!

[Typographics]

torachan,

Thank you so much for looking at this! I can't have the search criteria be a list, because there are thousands of unique identifiers, so the list would be enormous. It needs to be something I can type in.

[torachan]

As if by magic.
Changed Combo's to TextBoxes and small adjustments to code.
Try this.

[Typographics]

torachan,

Thanks for the edit! Sorry, yesterday was busy at work. I just wanted to thank you again.