Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2018, 07:50 AM
LearnerExcel LearnerExcel is offline Partial input text to work in auto search filter... Windows 7 32bit Partial input text to work in auto search filter... Office 2013
Advanced Beginner
Partial input text to work in auto search filter...
 
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
  #2  
Old 03-08-2018, 01:55 AM
ArviLaanemets ArviLaanemets is offline Partial input text to work in auto search filter... Windows 8 Partial input text to work in auto search filter... Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Wrong thread!
Reply With Quote
  #3  
Old 03-10-2018, 04:31 PM
NoSparks NoSparks is offline Partial input text to work in auto search filter... Windows 7 64bit Partial input text to work in auto search filter... Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Use regular autofilter and wildcard character (*).

Google "Excel filter as you type" to see another approach.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Partial input text to work in auto search filter... Auto-correct on existing text without input m9rbid Word 1 12-18-2017 01:20 PM
Filter Search Button lonniepoet Excel Programming 53 12-23-2015 02:27 PM
filter using wildcard doesn't work with Outlook 2007 clif9710 Outlook 0 07-15-2015 02:22 PM
Partial input text to work in auto search filter... How to Input Actual Overtime Work caveman Project 13 03-31-2015 05:24 PM
Partial input text to work in auto search filter... Insert input box into macro to allow user to define search term Hoxton118 Word VBA 3 05-19-2014 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft