+ Reply to Thread
Results 1 to 2 of 2

Option box that controls drop down menu

  1. #1
    Registered User
    Join Date
    07-25-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    86

    Option box that controls drop down menu

    Hi,
    I have made a spreadsheet test, that contains some test data in a 3 tier drop down system. I was just wondering if it would be possible for me to create two option boxes that regulate what goes in. For example, in the test sheet that i have attached, could i have an option box called "Data set 1" and "Data set 2", and when data set 2 option box is pressed the drop downs will contain the data from the page "Data 2" and the "Data set 1" option box would correspond to the first pages data.

    Any help is appreciated, if you could give me an idea of how to do it. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Option box that controls drop down menu

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
    https://www.excelforum.com/excel-pro...-dropdown.html
    Thread Closed.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

+ 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. Drop down menu with option to add figures
    By Legal_Consult in forum Excel General
    Replies: 6
    Last Post: 10-07-2015, 06:59 PM
  2. first option in a drop down menu
    By dawidski in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-13-2013, 12:57 AM
  3. [SOLVED] Drop Down Menu that Controls CF for Range of Cells
    By dompoma in forum Excel General
    Replies: 3
    Last Post: 04-21-2013, 07:07 PM
  4. Replies: 0
    Last Post: 06-25-2012, 03:22 PM
  5. Removing an option from a drop down menu after it is used.
    By heathD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2012, 12:53 PM
  6. Need an option added into a drop down menu
    By Ray_n_yellow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2009, 11:55 PM
  7. [SOLVED] add option to drop down menu
    By Vic in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 05:06 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