Use .Cells.Find(What:=) to find values in Multiple Cells

All,

I am currently using the .Cells.Find method to put values into my userform. It does well finding one specific value in a cell but I can't figure out how to get this method to look at two values in two different cells. For example, I would like it to do the following:

If column B = sFind value and column C = sFind2 value, then pull the values from that row into the userform.

Can anyone please help? I've looked everywhere and can't seem to find the solution that I am looking for.

Thank you in advance for your help.

Please Login or Register  to view this content.

If you need a certain value to be in two different cells in the same row, I would start at the top and move down one row at a time until you get to the row you need.

Please Login or Register  to view this content.

This is just what I would try, but someone else might have a better suggestion.

Originally Posted by AlphaFrog

This link explains it well. See the "What if I want to search for multiple occurrences of an item" section

The ultimate search

Using information from the article that AlphaFrog referred to, we can create a much more efficient search loop than the one I initially suggested. The below set of code uses the FindNext method to loop through all instances of strFind in Column 2 and for each one tests whether the cell in Column 3 of that same row also contains strFind.

Please Login or Register  to view this content.

Thank you so much AlphaFrog and MenacingBanjo! I will take a look and get back to you with my results. Thank you again!!

Originally Posted by s2jrchoi

I just noticed that the code is looking for strFind in column 2 and in column 3. I think I should have explained my situation more clearly but what I am looking for is to look up strFind in column B and then in column C...

If I'm not mistaken Column 2 and Column 3 are the same columns as B and C.
If you need to find "JH051320140933" in Column B, and a certain integer in Column C, then use the same code as above except instead of looking for strFind in Column 3, you look for whatever integer you need. In the example below, I used the number 1.

Please Login or Register  to view this content.

All,

Thank you for your help. I got it to work but I got the help from AlphaFrog's link because I did notice a few flaws in MB's code.

Please Login or Register  to view this content.

Thank you again!! I will mark this as solved.