VBA Search for Multiple Criteria

RoyJr 

If I understand correctly, then I think you will need to add an AND operator to your if statement to evaluate both conditions.

But, if you want to load multiple results into separate sets of text boxes, then I think you will need a counter variable to keep a running total of number of matches and then, based on that running total, load your next match in the next set of text  boxes set up to hold the results (the Select Case statement in the below example is set up for three).

However, if you think you might expand the number of matches in the future, you could use a list box with two columns to hold the matches. And, if you wanted to, you could add functions to update only matches you select from the listbox or all matches at once. I attached a screen shot as an example.

Private Sub CommandButton1_Click()
  Dim Current_Status As String
  dim count as long

  Current_Status=Trim(TextBox1.Text)
  lastrow=Worksheets("Overall").Cells(Rows.Count, 1).End(x1Up).Row

  For i =2 To lastrow
    With Worksheets("Overall")
      If .Cells(i, 1).Value=Current_Status And .Cells(i, 2).Value=CRITERIA2 Then
        count = count+1

        Select Case count
          Case 1
            TextBox2.Text = .Cells(i, 3).Value
            TextBox14.Text = .Cells(i, 11).Value
          Case 2
            ' Second set of textboxes here.
          Case 3
            ' Third Set of textboxes here, etc.
        End Select
      End If
    End With
  Next
End Sub