Dynamic excel filter 2 items at same time.

[louai]

Hello,


Is it possible to get this to work? Please check the test file below.



The target is getting tho rows at the same time when i search for like example opel+nissan

Test file:
https://ufile.io/xmpqu

 

[louai]

Test file at google drive:
https://drive.google.com/open?id=1lQKL_6z1wJbR9JB41oJdT4ZDT0voApMg

 

[MickG]

Try this:-

[COLOR="Navy"]Sub[/COLOR] MG26Nov26
Private [COLOR="Navy"]Sub[/COLOR] TextBox1_Change()
[COLOR="Navy"]Dim[/COLOR] Ray [COLOR="Navy"]As[/COLOR] Variant
[COLOR="Navy"]If[/COLOR] Len(TextBox1.Value) = 0 [COLOR="Navy"]Then[/COLOR]
    Sheet1.AutoFilterMode = False
    [COLOR="Navy"]Else[/COLOR]
        [COLOR="Navy"]If[/COLOR] Sheet1.AutoFilterMode = True [COLOR="Navy"]Then[/COLOR]
            Sheet1.AutoFilterMode = False
        [COLOR="Navy"]End[/COLOR] If
    Ray = Split(TextBox1, "+")
    Sheet1.Range("A2:F" & Rows.Count).AutoFilter field:=1, Criteria1:=Ray, Operator:=xlFilterValues  
    [COLOR="Navy"]End[/COLOR] If
 
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[louai]

Hello Mick,


wooooooow you are really a excel master!!!!


It worked for me and iam really impressed about your skills!!!!




Thankss

 

[MickG]

You're welcome