Results 1 to 5 of 5

Filter Table as i type in textbox1 but when erasing the text filter should be unfilter

Threaded View

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Post Filter Table as i type in textbox1 but when erasing the text filter should be unfilter

    hello

    i m using a userform with textbox1

    as i type in the textbox1 data filter automatically but there is one problem

    when i clear the text from textbox1 filter is not undo

    plz help

    code is here: and sample also attached
    Private Sub TextBox1_Change()
    
    Application.ScreenUpdating = False
    
    With Worksheets("Bills Obtain Date")
        Application.EnableEvents = False
            .Range("B2").Value = Me.TextBox1.Value
        Application.EnableEvents = True
        With .Range("Table1")
            If TextBox1.Value <> "" Then
                .AutoFilter Field:=2, Criteria1:="=" & Me.TextBox1.Text & "*"
            Else
                If ThisWorkbook.Sheets(.Parent.Name).AutoFilterMode Then .AutoFilter
            End If
        End With
    End With
    
    Application.ScreenUpdating = True
    
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table: field both as filter and row type
    By boooinky in forum Excel General
    Replies: 5
    Last Post: 09-26-2022, 02:46 PM
  2. [SOLVED] Need: filter, paste info to new sheet, rename sheet, unfilter, hide column, filter next
    By esmithqg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 04:49 PM
  3. Replies: 2
    Last Post: 04-08-2012, 09:43 PM
  4. Replies: 3
    Last Post: 03-15-2012, 10:01 PM
  5. VBA to actvate Unfilter after Auto Filter
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2008, 02:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1