#1
|
|||
|
|||
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 Last edited by LearnerExcel; 03-07-2018 at 09:41 PM. |
#2
|
|||
|
|||
Wrong thread!
|
#3
|
|||
|
|||
Use regular autofilter and wildcard character (*).
Google "Excel filter as you type" to see another approach. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
How to Input Actual Overtime Work | caveman | Project | 13 | 03-31-2015 05:24 PM |
Insert input box into macro to allow user to define search term | Hoxton118 | Word VBA | 3 | 05-19-2014 02:03 AM |