+ Reply to Thread
Results 1 to 2 of 2

PLEASE HELP!!! Using a ComboBox to Filter Data

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    WA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy PLEASE HELP!!! Using a ComboBox to Filter Data

    I've been working on this for days and just can't figure it out. I tried different options and methods and just can't get it to work! I'm pretty new to VBA so that might be part of the issue.

    I am trying to create a combo box that filters all my data based on three separate columns. These columns include either an 'X' or a blank in order to show whether or not the label applies to that specific row (Major, Minor, or New Launch). In most cases, two or more labels (of 3) apply to the same row (aka they are not mutually exclusive). I have the combobox populated with these options, but I can't make the filter work quite right.

    I linked the combobox to one cell (B6) and used the following formulas to populate the advanced filter criteria.
    =IF((B6="MINOR"), "X", "")
    =IF((B6="MAJOR"), "X", "")
    =IF((B6="NEW LAUNCH"), "X", "")


    The problem is that the filter thinks I am looking for options that include all three labels as it is not recognizing that those cells are empty.

    There is also a row specifying change level (1, 2, or 3) which is where the labels come from. Minor = 1, Major = 2, New Launch = 1,2, or 3. I also tried setting the filter based on that single column and couldn't get that to work either. I successfully filtered by 1, 2, or 3 (which was not exactly what I wanted, but I was willing to live with it), but I couldn't get the file to unfilter when [blank] cell was selected as the formulas linked to the combobox could not output a true blank (Excel sees it as 0).
    Attached Files Attached Files

  2. #2
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: PLEASE HELP!!! Using a ComboBox to Filter Data

    I needed to be able to filter based on a few different criteria as well and was also working on it without luck for a few days and just finished it because of this.

    http://www.youtube.com/watch?v=LRDTWDuTSNY

    If it helps, I attached the end result of how I used it at my post.

    http://www.excelforum.com/excel-prog...ml#post3434450

    Just put a few records in with the cells in column B and D filled with something from the dropdown menus and then select something to filter on from the filter dropdowns above in B5 and D5. You can have multiple filters per column on each column throughout the table, which I may add more, but right now I only had a need for two.

    I hope it helps.
    -------------
    Tony

+ 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. Macro to filter data to search terms selected from ComboBox (Form Control)
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2013, 05:08 PM
  2. [SOLVED] Create a filter using combobox and data from excel
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 05:42 AM
  3. [SOLVED] Help! VBA Code to disable macros and filter data for combobox in userform
    By ChristianMba in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-23-2012, 06:42 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. Combobox - Filter auto-filter worksheets (ActiveX)
    By Darms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2011, 11:33 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