+ Reply to Thread
Results 1 to 7 of 7

Displaying results based on Combo box value EXCEL 2010

  1. #1
    Registered User
    Join Date
    01-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Displaying results based on Combo box value EXCEL 2010

    I have a problem with using a combo box in Excel 2010.
    I have created two combo box. One of them is displaying a list of location while another one is displaying a list of occupation.
    I need to display results from an employee table when user selects both of the options from the combo box.
    How do I do that? I can't read the value stored inside combo box.
    Thanks !
    Attached Files Attached Files
    Last edited by mizacasa; 01-23-2012 at 02:54 AM.

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Displaying results based on Combo box value EXCEL 2010

    hi,
    I'm not sure what you want, could you upload a test file with yr comboboxes and some examples and the result you want?
    maybe someone might have a solution for you!
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Displaying results based on Combo box value EXCEL 2010

    Simpler to use Data Validation - the List feature
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    01-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Displaying results based on Combo box value EXCEL 2010

    Hi there.
    I have attached a file at my post. please take a look at it. hope you can help!
    Thanks.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Displaying results based on Combo box value EXCEL 2010

    What's wrong with using AutoFilter?

  6. #6
    Registered User
    Join Date
    01-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Displaying results based on Combo box value EXCEL 2010

    I really don't know. If i can, i would LOVE TO USE AUTOFILTER. but, my homework has to do in the other manner.
    I wouldn't burden myself if I can use autofiler.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Displaying results based on Combo box value EXCEL 2010

    We don't do homework

+ Reply to Thread

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