Results 1 to 6 of 6

Excel Combo Boxes and Filtering a Data Set

Threaded View

dec789 Excel Combo Boxes and... 09-10-2012, 08:28 PM
benishiryo Re: Excel Combo Boxes and... 09-10-2012, 10:45 PM
dec789 Re: Excel Combo Boxes and... 09-11-2012, 08:58 AM
dec789 Re: Excel Combo Boxes and... 09-11-2012, 09:02 AM
benishiryo Re: Excel Combo Boxes and... 09-11-2012, 10:10 PM
dec789 Re: Excel Combo Boxes and... 09-12-2012, 08:18 AM
  1. #1
    Registered User
    Join Date
    08-25-2012
    Location
    La Habra Heights, CA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Excel Combo Boxes and Filtering a Data Set

    Not sure this is even possible but....
    I would like to have a series of 4 combo boxes "link" to each other (Not sure if link is the correct term here) in a way that mimics filtering a data set in an Excel spreadsheet.

    After the user chooses a value in combo-box 1 (column A)
    I would like to "filter" the options in combo-box 2 (column B) to only values in (column B) that correspond with values in the (column A) = selection in combo-box 1.

    This "Filtering" of data that populates each combo box would flow down through to the third and fourth combo boxes.

    Do I need to make lists of all the possible filtering combinations or can the filtering be done dynamically?

    The attached form has an example of the 4 combo boxes and data I'm working with.

    For my example combo boxes I used data validation cells. Maybe I need to use an Active X or Form comb box - not sure about the differences here.

    Thank you!
    Attached Files Attached Files
    Last edited by dec789; 09-11-2012 at 09:05 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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