+ Reply to Thread
Results 1 to 4 of 4

Toggle between filter and unfiltered

  1. #1
    Registered User
    Join Date
    04-19-2015
    Location
    Kihei Hawaii
    MS-Off Ver
    2016
    Posts
    33

    Toggle between filter and unfiltered

    I am trying to create a but that will toggle between filtered and Unfiltered data,
    Please Login or Register  to view this content.
    It doesn't quite work as expected it will filter but then it will unfiltered without prompt, Like I am missing a stop. I want the user to press a button and the data is filtered. If they press it again it will be unfiltered.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Toggle between filter and unfiltered

    Why not use two buttons. To turn autofilter off, you need only this subroutine via a second button:

    Please Login or Register  to view this content.
    The first button can be simply:

    Please Login or Register  to view this content.
    Let us know if this does not answer your question

  3. #3
    Registered User
    Join Date
    04-19-2015
    Location
    Kihei Hawaii
    MS-Off Ver
    2016
    Posts
    33

    Re: Toggle between filter and unfiltered

    I was hoping to do it with one button, but for now I will have two. Thanks

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Toggle between filter and unfiltered

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ 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. [SOLVED] Toggle PivotTable Filter for All Pivots on a Worksheet
    By vwhite in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2020, 12:51 PM
  2. Toggle switch to filter data
    By shanil6666 in forum Excel General
    Replies: 2
    Last Post: 12-16-2018, 01:51 AM
  3. [SOLVED] Use Toggle Button to filter
    By biznez1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2018, 06:16 AM
  4. Toggle Filter
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2017, 11:42 AM
  5. [SOLVED] Toggle button to apply filter criteria
    By Storic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-12-2016, 11:51 AM
  6. Toggle button to turn on/off a filter
    By jcmckeon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2016, 03:15 PM
  7. Quickly toggle between filtered/unfiltered view for all worksheets in a workbook.
    By theirlaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2012, 10:55 PM

Tags for this Thread

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