+ Reply to Thread
Results 1 to 5 of 5

Fill combo box list based on other combo box values

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Fill combo box list based on other combo box values

    column A--------------Column B
    Cust1-------------------11
    Cust2-------------------22
    Cust3-------------------33
    Cust1 ------------------44
    Cust2-------------------55
    Cust3-------------------66
    Cust1-------------------77
    Cust2-------------------88
    Cust3-------------------99

    My work sheet is like abow. now in combobox1 i have list from column A and combobox2 have list from columnB
    if I select "Cust1" in combobox1 then combobox2 list should show only 11,44,77 values.
    hope I am not confusing....
    Thank You.

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Fill combo box list based on other combo box values

    I think you have to do it via a form, not just from 2 combo boxes in the sheet.
    The attached workbook handles it. You may have to adjust the location of the CustVals named range depending on your exact contents

    FilteredCombo.xlsm

  3. #3
    Registered User
    Join Date
    04-16-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Fill combo box list based on other combo box values

    I have made user form for that...
    Thank You very Much hectop. I don'd know much about VBA. but I am trying to learn new things................

  4. #4
    Registered User
    Join Date
    04-16-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Fill combo box list based on other combo box values

    query has been solved but facing one problem that, when I add new raw like in column A cust1 and in column B 123, in combo box 2 123 do not appear changing combo box 1 at first. need to close user form and reopen than newly added value comes in combo box 2.........
    Last edited by rain4uu; 10-24-2013 at 01:55 AM.

  5. #5
    Registered User
    Join Date
    04-16-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Fill combo box list based on other combo box values

    solved OK.
    Last edited by rain4uu; 10-24-2013 at 12:42 PM.

+ 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. [SOLVED] Fill Combo and List Box with items from A1:A5
    By LadyB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-11-2013, 02:22 PM
  2. Fill Combo box with alternatives based on list
    By Pero in forum Excel General
    Replies: 0
    Last Post: 03-02-2011, 05:17 PM
  3. How to fill List in Combo Box from Design
    By Resant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2006, 05:20 AM
  4. Filtered list for Combo Box ListFillRange - Nested Combo Boxes
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2006, 08:20 AM
  5. Combo box values based on other combo box value
    By JCanyoneer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2005, 02:06 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