+ Reply to Thread
Results 1 to 6 of 6

Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    I've been looking all over for this. I am attaching my workbook. I use Excel 2007.
    I have comboboxes on my userform, I have cbo1 working correcty - list is from Named range. I would like Cbo2 to use the value in cbo1 to pull from that named range.
    I have in the first list OptionX, Option_S, OptionW, and OptionP. There are ranges named OptionX...
    Here is what I have so far:
    Please Login or Register  to view this content.
    I am also attaching the WB.

    Any help would be great!
    Thanks
    Attached Files Attached Files
    Last edited by CRIMEDOG; 11-10-2010 at 04:04 PM.

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    Hi CRIMEDOG

    If you add this code, I believe it does as you require
    Please Login or Register  to view this content.
    Let me know of issues.
    John
    John

    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.

  3. #3
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Re: Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    Great -Work great.

  4. #4
    Registered User
    Join Date
    06-20-2011
    Location
    London England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    I am trying to do the same sort of thing but with dynamic ranges, variable number of options in each combo box and a group of 4 combo boxes.

    Before trying to work out the code I am working on the excel dynamic ranges using ‘Match’ from the first option to provide the offset reference point for the second ‘Match’.

    '=OFFSET((CELL("address",INDIRECT(CONCATENATE("R",ROW($KJ$31)+((MATCH($JQ$25,$KI$32:$KI$131,0))),"c",COLUMN($KJ$31)),FALSE))),MATCH($KJ$26,$KJ$32:$KJ$131,0),4,COUNTIF($KJ$32:$KJ$131,$KJ$26),1)

    Reference for offset based on first selection = ____
    Match of data second option = ____
    Number of items in second option = _____

    If this does not work I can go back to creating each option list separately, which may be simpler.

    I can get for option boxes working sequentially in the excel workbook. However, I am trying to move all user interfaces to userforms.

    I know there are effectively two questions here but I am only looking for one solution.

    All help welcome.

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    Hi bojum01

    Welcome to the Forum.

    Unfortunately, you've posted a question in another OP's thread...this doesn't sit well with Forum Rule #2
    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.


    In addition to that, this thread has been marked as solved and will probably not get much traffic. I'd suggest you start a new thread for your issue.

  6. #6
    Registered User
    Join Date
    06-20-2011
    Location
    London England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

    Thanks for your help. I have started an new thread called Userform Dependant Combobox

+ 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