Contains Filter VBA

[pure vito]

Hi All,

I have this code that allows me to search trough a list of items and it works great however some of those items contain two words and the filter doesn't
search for that is someone able to amend this code to use a contains filter please, Thanks in advance.

Private Sub Worksheet_Change(ByVal Target As Range)
'Updateby Extendoffice 20160606
  Application.ScreenUpdating = False
  Range("B10").Select
    Selection.AutoFilter
    Selection.AutoFilter
    Range("B4").Select
   If Target.Address = Range("B4").Address Then
       Range("B11:i30000").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("B3:B4")
       Application.ScreenUpdating = True
   End If
End Sub

 

[Alex Blakenburg]

Sounds like I am late to the party on all counts. Thanks for the feedback and glad we could help.

 

[pure vito]

@Peter_SSs but but but .... I was busy writing all the reasons why we needed the XL2BB . Mine looks just like your although I didn't think to test for no data and I did add screenupdating and enableevent.

Peter provided a link the XL2BB web page both under the word and in his sign off.
Images mean we have to manually create the data. It also often also does not provide all the information as is the case with your images. No Row Numbers or Column references, no sheet name and often data types and formulas come into play as well.

Aha you came that's the most important part thank you ever so much you had the answer I wasn't able to execute it , yes again apologies for the lack of information and I will defiantly look into adding and using XL2BB it did pop up on my document for a short time then disappeared I'll keep working at it, But if the contents of my data sheet sparked any interest please take a look at my document I have spent the best part of a year working on it you might be able to offer some advise oh there's a trick to opening the document let me know if you crack it Pokemon Collection Tracker Ver 1.2.xlsm it's a large document and will need downloading

 

[Alex Blakenburg]

You have way more patience than me. You might want to remove the file though. Unless you know what you are doing it locks up your Excel. I don't think that I used your "trick" to opening it.

 

[pure vito]

That's the intention, I wanted the welcome screen to do that until you exit the screen, you have to press Pikachu's belly to open it up , but yeah I put a lot of time into that and still working on it when I can.

 

[Peter_SSs]

and I did add screenupdating and enableevent.

I didn't bother with screen updating as I was in a hurry to rush out for the evening & figured the OP already knew how to do that from the opening post code.
I don't think enableevents is relevant for this code as the code does not trigger itself.