+ Reply to Thread
Results 1 to 6 of 6

I need to make a dependant combobox

  1. #1
    Registered User
    Join Date
    11-30-2011
    Location
    switzerland
    MS-Off Ver
    Excel 2007
    Posts
    7

    I need to make a dependant combobox

    Hi all,


    I have a project where I want to use two (at least) comboboxes to filter information. The seconds list will be based on the first.

    This seems to be a basic thing and I have seen code snippets but nothing that has worked to be honest.


    A basic example would be very welcome.

    I can provide the input tables if necessary.


    Regards,
    Pete

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need to make a dependant combobox

    Try this link - http://www.contextures.com/xldataval02.html
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    11-30-2011
    Location
    switzerland
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: I need to make a dependant combobox

    You cant use comboboxes? The reason I ask is that I will have to filter on the value that is stored in the second box. Which as far as I can tell i cant get from a validation box.

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need to make a dependant combobox

    I am not able to understand your requirement. Maybe you can post a sample workbook.

  5. #5
    Registered User
    Join Date
    11-30-2011
    Location
    switzerland
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: I need to make a dependant combobox

    ok,

    Ill try to explain. We have a table of products. We want people to be able to filter this table on their own without seeing or editing the orignal table. The table is made up of 9 categories each with between 3 and 9 subcategories.

    sooo, What I want is them to first pick a category using a combobox. Then based on their first response choose a specific subcategory in the second. then they hit a execute button and it does the filtering and produces a list which they can further play with.

    Ideally, I would use two comboboxes and then a commandbutton to get the first list.

    I have included the spreadsheet that im working with currently. this is the data made to do the filtering. the actual product data is in a different table.


    Hopefully, its a bit clearer.

    Regards,
    Pete
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need to make a dependant combobox

    Yeah 2 dependent dropdowns will work in this case. For the button you need a macro that will filter the results for you. The results can be filtered on another sheet if you do not want the users to disturb the original sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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