+ Reply to Thread
Results 1 to 5 of 5

Filter multi data Using combobox and checkboxes

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

    Post Filter multi data Using combobox and checkboxes

    hello
    i have a data sheet
    i want to filter my multi data using combobox and checkboxes,,,

    checkbox filter data what value is in the combobox,

    thanx
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: Filter multi data Using combobox and checkboxes

    I have made a simple example where I replace your 4 comboboxes & 4 checkboxes with 1 listbox. You can multiselect items in your listbox. Maybe this is something you can use.

    FILTER%20SAMPLE(1).xlsm

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

    Re: Filter multi data Using combobox and checkboxes

    Hello Joakim N

    if i unchecke all list then unfilter the all data,....if i check one option then i uncheck filter is not unfiltring and debug is occurring

    solve this problem


    BTW listbox is good option instead of comboboxes and checkboxes

  4. #4
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: Filter multi data Using combobox and checkboxes

    I was leaving something to solve yourself. I just gave you some tip. However, I have added some more code to previous file.

    FILTER.xlsm

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

    Re: Filter multi data Using combobox and checkboxes

    Thanx Joakim N

    works perfect

    +1 repu will add u

+ 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. PLEASE HELP!!! Using a ComboBox to Filter Data
    By apiro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 01:01 AM
  2. [SOLVED] Data Manipulation: How to dynamically filter and sort a multi-column data set
    By deturnbull in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-12-2013, 05:35 AM
  3. Macro to Filter unique rows of data based on multi criteria
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 07:33 PM
  4. filter data using combobox
    By suresh mongam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2012, 05:20 AM
  5. Multi filter on data
    By scooterboygnu in forum Excel General
    Replies: 1
    Last Post: 09-06-2011, 12:15 PM

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