+ Reply to Thread
Results 1 to 2 of 2

Filter rows with multiple buttons/check boxes?

  1. #1
    Registered User
    Join Date
    09-23-2018
    Location
    North Pole
    MS-Off Ver
    Spreadsheet
    Posts
    1

    Filter rows with multiple buttons/check boxes?

    Hi, I wasn't sure where to post this, so I'm putting it here. My apologies if I'm wrong!

    Like the title says, I am trying to find out a way to have check boxes to filter rows in a table.
    I know there is already a Filter drop down menu I can open on the top of the column, but I'm looking for a way to add check boxes instead.

    For example:
    If I have a table of data A1:E10, and in column 'C' I have different words, such as 'Apple', 'Orange', 'Banana', etc., could I create check boxes to filter the rows visible by the words in column 'C'? Like a check box for 'Apple', one for 'Orange', etc.

    And is it possible to have multiple boxes enabled at once, like if I wanted to see rows that contained the words 'Apple' and 'Orange' together, then could I just check the boxes for 'Apple' and 'Orange' at the same time?


    Sorry, I'm really not any good at this stuff, and worse at explaining it lol

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Filter rows with multiple buttons/check boxes?

    .
    The simple answer is yes.

    The easiest method to achieve your goal would be to use the MACRO RECORDER to create the macro of filtering per your actions. Then you can
    connect a command button or checkbox to the finished macro.

+ 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. Replies: 3
    Last Post: 05-03-2016, 11:43 PM
  2. [SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 11:32 PM
  3. [SOLVED] VBA Radio buttons that select multiple UserForm check boxes
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2014, 12:13 PM
  4. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  5. How to insert Buttons, radio buttons and check boxes in Excel
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 08:13 AM
  6. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  7. Check boxes and Option buttons
    By Chris Martin in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 04:21 AM

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