cascading combo boxes...??? - Page 3
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 12 FirstFirst 12345 ... LastLast
Results 21 to 30 of 116

Thread: cascading combo boxes...???

  1. #21
    New Member
    Join Date
    Jun 2004
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Aladin,
    I'm not sure what you are asking here.
    Daniel

  2. #22
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    Quote Originally Posted by djd79
    Aladin,
    I'm not sure what you are asking here.
    Daniel
    I'm asking for example data along with a description of the way you want the lists to be dependent.

  3. #23
    Board Regular
    Join Date
    Aug 2004
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: cascading combo boxes...???

    I was wondering if it is possible for the indirect function as described above to work for dynamic ranges. I have tried it but the pull down in the second column does work. If I make the range a fixed range it works, however I would really like to have the dynamic range.

    Mark

  4. #24
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: cascading combo boxes...???

    Quote Originally Posted by Mark_G
    I was wondering if it is possible for the indirect function as described above to work for dynamic ranges. I have tried it but the pull down in the second column does work. If I make the range a fixed range it works, however I would really like to have the dynamic range.

    Mark
    See for an approach:

    http://www.mrexcel.com/board2/viewto...set+validation

  5. #25
    Board Regular
    Join Date
    Feb 2004
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: cascading combo boxes...???

    Indirect function together with several dropdown menus with data - validation <<<---- Is this possible? Ive got two dropdown menus and they are working like a charm. However, i want to have 3 or 4 dropwdown menus and depending of which choice i choose from the first 2-3 i will get some new choices from in the 4th dropdown menu.. Ive tried tha indirect function but i can only get this working together with 2 dropdowns..

    Eric

  6. #26
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,697
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes. Check out Juan's contrib here ... http://www.vbaexpress.com/forum/showthread.php?t=1072

    I also have a workbook example with this in place already. If you'd like a copy, pm me with your email addy.
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  7. #27
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: cascading combo boxes...???

    Quote Originally Posted by zanoman
    Indirect function together with several dropdown menus with data - validation <<<---- Is this possible? Ive got two dropdown menus and they are working like a charm. However, i want to have 3 or 4 dropwdown menus and depending of which choice i choose from the first 2-3 i will get some new choices from in the 4th dropdown menu.. Ive tried tha indirect function but i can only get this working together with 2 dropdowns..

    Eric
    As long as you define the sublists as referring to definite ranges (thus, not using formulas with OFFSET, INDEX...), INDIRECT() will suffice to construct cascading or dependent lists...

    ******** ******************** ************************************************************************>
    Microsoft Excel - aaCascadingDataValidLists zanoman.xls___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    B
    C
    D
    E
    F
    G
    1
    2
    FRANCE COUNTRIES USAFRANCE
    3
    USA New YorkParis
    4
    Nice FRANCE PittsburghNice
    5
    6
    NIC1 NewYorkParis
    7
    N1PAR1
    8
    N2PAR2
    9
    10
    PittsburghNice
    11
    P1NIC1
    12
    P2NIC2
    13
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    COUNTRIES refer to:

    =Sheet1!$D$3:$D$4

    USA refers to:

    =Sheet1!$F$3:$F$4

    FRANCE refers to:

    =Sheet1!$G$3:$G$5

    NewYork (without space) refers to:

    =Sheet1!$F$7:$F$8

    Pittsburgh refers to:

    =Sheet1!$F$11:$F$12

    Paris refers to:

    =Sheet1!$G$7:$G$8

    Nice refers to:

    =Sheet1!$G$11:$G$12

    Data validation in B2...

    Allow set to List, Source to:

    COUNTRIES.

    Data validation in B4...

    Allow set to List, Source to:

    =INDIRECT(B2)

    Data validation in B6...

    Allow is set to List, Source to:

    =INDIRECT(SUBSTITUTE(B4," ",""))

  8. #28
    Board Regular
    Join Date
    Feb 2004
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: cascading combo boxes...???

    How about dropdown menu with data validation and checkboxes? From a pulldown menu you are allowed to pick a checkbox containg "X" or a chackbox containing "V". As in ok (V) and not ok (X). Is this "doable"?


    Eric

  9. #29
    Board Regular TTom's Avatar
    Join Date
    Jan 2005
    Location
    Oregon
    Posts
    518
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried the USA-FRANCE example...
    It answered who to access Data Validation List from another sheet's data AND how to do a parent - child relationship.
    SWEET! TTom
    Yesterday gives us the tools today to create our tommorrow... tt

  10. #30
    New Member
    Join Date
    Feb 2005
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Match function

      
    thanks for the info. but I'm have 4 columns of data validation. each one is dependent on the previous. And the issue is when any of the data values is duplicated, Excel doesn't handle this well with the formula I'm using with INDIRECT and MATCH.

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
  •  

 

 
DMCA.com