cascading combo boxes...??? - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 12 FirstFirst 1234 ... LastLast
Results 11 to 20 of 116

Thread: cascading combo boxes...???

  1. #11
    New Member
    Join Date
    May 2002
    Location
    Switzerland
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Great Stuff!
    I'd like to push it forward:
    After you choose a country (USA) and a city, you may want then to choose another country in A1. The only thing is that the city from USA is still in the other cell.
    Is there any (dynamic?) macro in order to delete the already choosen city when you change the selected country.
    Regards
    Emmanuel

  2. #12
    New Member
    Join Date
    May 2003
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Many thanks. This is the first time I have used this service and will certainly do so again.

  3. #13
    Board Regular
    Join Date
    Jul 2003
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Is there a way to get this method to work with non-adjacent named ranges, like from an existing database?

  4. #14
    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 Re: cascading combo boxes...???

    Quote Originally Posted by mgana
    Is there a way to get this method to work with non-adjacent named ranges, like from an existing database?
    as far as i know, named ranges will only work within it's own workbook. they can work cross-sheets which is very nice. maybe copying one sheet to another workbook and accessing from there? many possibilities.
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  5. #15
    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 mgana
    Is there a way to get this method to work with non-adjacent named ranges, like from an existing database?
    How do you mean?

  6. #16
    New Member
    Join Date
    Apr 2004
    Location
    San Francisco
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    'Is there any way in which i can get the drop down arrows to stay there permanently? because i need a visible menu option."

    is it possible to tell me how to do it in VBA?

    Thanks!!
    Cathy

  7. #17
    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

    try looking at making a combo box.
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  8. #18
    Board Regular
    Join Date
    Jun 2002
    Location
    Perth, Australia
    Posts
    1,416
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Gurps,

    You could do this with “real” combo boxes.

    See the exhibit:
    Your data is in sheet2, columns G, H and I.
    It is assumed that the max number of rows for the data is 20 (column H).

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

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    CodeCategoryData Code
    2
    101AA500 Category
    3
    39 102BA501 Data
    4
    103CA502
    5
    2$I$2:$I$20 104DA503
    6
    105EA504
    7
    106FA505
    8
    107GA506
    9
    108HA507
    10
    109I
    11
    110J
    12
    111K
    13
    112L
    14
    M
    15
    N
    16
    Named ranges: O
    17
    Master=INDIRECT(Sheet2!$D$5) P
    18
    MyData=Sheet2!$K$1:$K$3 Q
    19
    R
    20
    S
    21
    Sheet2

    [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.


    Step 1
    In column K, list your data headings and name this list as “myData”.

    Step 2
    D3: put the formula -
    =$C$3+6

    From the Forms menu, create a Combo box that covers cells C3:D3.
    The input range is “MyData” (no quotes)
    Cell link is $C$3.

    By covering cells C3:D3 with the Combo Box, you are hiding the formula in D3 and the link cell in C3.

    Step 3
    D5: put the formula -
    =(ADDRESS(2,D3) &":"&ADDRESS(20,D3))

    Note that the formula in D5 is linked to the formula in D3 (step 2 above).

    Step 4

    From the Insert menu | Name | Define, create a named range called “Master” that refers to “=INDIRECT(Sheet2!$D$5)” (no quotes).

    Step 5

    From the Forms menu, create another Combo box that covers cells C5:D5.
    Input range is “Master” (no quotes)
    Cell link range is $C$5.

    Again, by using the second combo box to cover cells C5:D5, you are hiding the link cell in C5 and the formula in D5.

    That’s it.

    Access the first combo box and make a selection. The second combo box will reflect your choice from the first combo box.

    HTH

    Mike

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

    Default

    Going back to the example give by Aladin at the beginning of this post…..

    What if I have three lists? The combination of the first 2 lists will restrict the data that I am able to select in the third list?

    I have 12 items in the first list, 26 items in the second list and about 250 items in the 3rd list.

    Thanks,
    Daniel

  10. #20
    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
    Going back to the example give by Aladin at the beginning of this post…..

    What if I have three lists? The combination of the first 2 lists will restrict the data that I am able to select in the third list?

    I have 12 items in the first list, 26 items in the second list and about 250 items in the 3rd list.

    Thanks,
    Daniel
    Can you give a sized down set that shows the interdependence you're looking for?

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