Thread: Partial input text to work in auto search filter...
View Single Post
 
Old 03-07-2018, 07:50 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2013
Advanced Beginner
  
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Partial input text to work in auto search filter...
The following code is working fine but I need to input full text of a cell to get the result. How to modify this code to search with partial input text that shows the related rows?

Code:
 
Private Sub Worksheet_Change(ByVal Target As Range)
'Updateby Extendoffice 20160606
   If Target.Address = Range("M2").Address Then
       Range("A3:M700").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("M1:M2")
   End If
End Sub
Note: For Example, Cell M300 has the data "FFCE4600" and If I input text in M2 as "FFCE" it shows all the records which contains text FFCE but when I input "4600" it shows nothing. How to resolve this problem?
Last edited by LearnerExcel; 03-07-2018 at 09:41 PM.
Reply With Quote