Results 1 to 2 of 2

Thread: Drop down menu choice decides other cell values

  1. #1

    Question Drop down menu choice decides other cell values

    Register for a FREE account, and/
    or Log in to avoid these ads!

    i'm trying to get a neighbouring cell (b2) populated by the next value in a drop down lists selected in cell A1. For example the user selects orange from a drop down menu in cell A1, B2 is automatically populated by the next value in the list - blue.

    Not sure if this possible but your help would be appreciated


  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Derbyshire, UK
    Excel Version
    most versions
    I think the simplest way would be to use a ComboBox from the Forms controls.

    Add a ComboBox from the Developer Tab in the newer versions of Excel, or versions prior to Excel 2007 you will need the Forms ToolBar. You must use the Forms version.

    Right Click on the ComboBox & choose Format.

    Input Range refers to the List
    LinkedCell can be any unused cell

    To get the selected item in a cell


    To get the next in the list

    Attached Files Attached Files
    Hope that helps


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts