+ Reply to Thread
Results 1 to 3 of 3

Using Output of One Combo Box to Dictate Options Shown in a Second Combo Box?

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    New York
    MS-Off Ver
    2013
    Posts
    1

    Using Output of One Combo Box to Dictate Options Shown in a Second Combo Box?

    I am trying to set up where I have a combo box with 10 different options to select from, (for example lets say they're 10 different t-shirts). Based on what the user selects I want to then in the column right next to it display options for that t-shirt (let's say the different colors available). But the colors for each t-shirt are different for each one so the second combo box has to be reactive to the answer of the first combo box.

    Any help with if this is possible? And second any help with building the logic behind it if possible would be so great!

    Thanks!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,230

    Re: Using Output of One Combo Box to Dictate Options Shown in a Second Combo Box?

    Lookup dynamic data validation
    Ben Van Johnson

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Using Output of One Combo Box to Dictate Options Shown in a Second Combo Box?

    This might be of some use. At least it is a start. The ActiveX combo box in my example fills A2 which is named Input. There are 4 named ranges that are accessed by the content of A2 via INDIRECT. If you edit the properties of the combo boxes some of the edits will not be in effect until you save, quit and restart the file (found out by trial and error).
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Combo Box with options depanted of another combo box.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2014, 04:34 AM
  2. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  3. [SOLVED] How to reference a second Combo box’s output based on previous Combo Box’s Row source
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 11:27 AM
  4. Cell options/combo box?
    By Paulymon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2006, 02:50 PM
  5. Options and Combo Boxes
    By mtm4300 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2006, 02:10 PM

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