+ Reply to Thread
Results 1 to 5 of 5

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

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

    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
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

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

    Hi haroon2015

    Try this
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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

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

    Thanx jaslake

    now working very fine.

    +1 repu will add u

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

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

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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

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

    hello jaslake
    already used the star icon at the lower left of their post.

+ Reply to Thread

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