Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Multiple cascading drop down lists

  1. #1
    New Member
    Join Date
    Nov 2008
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple cascading drop down lists

    hi all-

    I'm trying to create a cascading drop down list that has two initial fields before the final field option is given. All the examples I've seen online only deal with two total fields (example: http://www.contextures.com/xlDataVal13.html).

    The data that I have includes Country, State and then City and the only way to get to the correct city is by selecting an appropriate country and state (with each choice narrowing the options). I don't think this is possible with data validation (although, I'm not sure).

    Any help would be greatly appreciated as I don't really want to code this out with combo boxes.

    thanks,
    ghost

  2. #2
    Board Regular sous2817's Avatar
    Join Date
    Feb 2008
    Location
    Raleigh, NC
    Posts
    2,276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple cascading drop down lists

    It is possible, you basically keep repeating the process for each additional subset. Take a look here:

    http://www.contextures.com/xlDataVal02.html
    "Even a blind pig finds an acorn now and again"

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    - Search Mr. Excel using Google

    - Search Mr. Excel using Bing

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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