+ Reply to Thread
Results 1 to 3 of 3

Input Range for Combo Box

Hybrid View

Srikanth H N Input Range for Combo Box 02-10-2011, 06:48 PM
royUK Re: Input Range for Combo Box 02-11-2011, 06:03 AM
DonkeyOte Re: Input Range for Combo Box 02-11-2011, 09:06 AM
  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    Bangalore, India
    MS-Off Ver
    MS Excel 2010
    Posts
    49

    Smile Input Range for Combo Box

    Hello,
    I have a Range from cell A1 to A3 named RAW which contains departments (Finance, Marketing, Production) and this is getting populated in combo box as list.
    I have another combo box (2nd combo box), in which the list should appear based on the input in combo box1. eg. If i select Finance in combo box 1, then in combo box 2 list should show only AA, AB and AC, if I select Marketing in combo box 1, then in combo box 2 list should show only BA, BB and BC.
    AA, AB, AC, BA, BB, BC are in cell B1 to B6.

    How to create the input range for combo box 2 based on combo box1?

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

    Re: Input Range for Combo Box

    What kind of ComboBoxes?
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Input Range for Combo Box

    You might consider "standard" dependent data validation

+ 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