+ Reply to Thread
Results 1 to 3 of 3

Dropdown boxes (box 1 result = box 2

  1. #1
    Greg
    Guest

    Dropdown boxes (box 1 result = box 2

    I'm trying to use a dropdown box that after choosing will create choices for
    dropdown box 2.
    box 1:
    1
    2
    3
    box 2:
    1 orange
    1 blue
    1 green
    2 yellow
    2 purple
    2 black
    3 etc etc etc

    Any idea?
    thanks in advance, greg

  2. #2
    Guest

    Re: Dropdown boxes (box 1 result = box 2

    Hi
    Have a look here:
    http://www.contextures.com/xlDataVal02.html

    --
    Andy.


    "Greg" <Greg@discussions.microsoft.com> wrote in message
    news:3EF35122-3736-4AF5-ACDA-F6CAD57FE87D@microsoft.com...
    > I'm trying to use a dropdown box that after choosing will create choices
    > for
    > dropdown box 2.
    > box 1:
    > 1
    > 2
    > 3
    > box 2:
    > 1 orange
    > 1 blue
    > 1 green
    > 2 yellow
    > 2 purple
    > 2 black
    > 3 etc etc etc
    >
    > Any idea?
    > thanks in advance, greg




  3. #3
    Louis Pretorius (Johannesurg, RSA)
    Guest

    RE: Dropdown boxes (box 1 result = box 2

    Hi Greg
    Create named lists of the vairous drop-downs you want.
    Do a data validation, and in the Source, do ifs
    =if($A$1="XXX",LIST1,if($A$1=YYY,LIST2,ERROR)) etc

    Cheers
    Louis

    "Greg" wrote:

    > I'm trying to use a dropdown box that after choosing will create choices for
    > dropdown box 2.
    > box 1:
    > 1
    > 2
    > 3
    > box 2:
    > 1 orange
    > 1 blue
    > 1 green
    > 2 yellow
    > 2 purple
    > 2 black
    > 3 etc etc etc
    >
    > Any idea?
    > thanks in advance, greg


+ 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