Live Search MULTIPLE fields SIMULTANEOUSLY [search as you type]

[deannaed]

Hi Everyone

Please assist.
I am currently using the following to search through the data as I type.

Please advise how the any code changes that will allow me to search more than one column at a time.

Currently if i search in Column A and then continue to enter a search criteria in any other searchable column - the initial criteria are 'over written '.

I hope i am clear.

Thanks in advance


*I have attached the file*

Below is the code for each box

Private Sub TextBox2_Change()

If Len(TextBox2.Value) = 0 Then
    Sheet1.AutoFilterMode = False
Else
    If Sheet1.AutoFilterMode = True Then
     Sheet1.AutoFilterMode = False
    End If
Sheet1.Range("A2:R" & Rows.Count).AutoFilter field:=2, Criteria1:="*" & TextBox2.Value & "*"
End If

End Sub

 

[Marc L]

Hi !

Use Range.Find method as per its VBA help example
or an advanced filter …
​

 

[deannaed]

Hi Marc L

Thank You for the response.

Please be kind enough to advise me on how to achieve this

 

[Marc L]

Or just try without the codelines in the Else part of your code …​