cascading combo boxes...???
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 12 12311 ... LastLast
Results 1 to 10 of 116

Thread: cascading combo boxes...???

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    is there any way in which I can get the selection from one combo box to influence the second?? In other words, The second combo box is dependant on the first.
    I am using Excel XP.

    any help would be appreciated.
    cheers

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you could use Data Validation, I posted a Tip of the Day that explains this.

    If you need to do this using "real" comboboxes, then, post again.

    Tip of the Day for:
    Saturday, January 26, 2002
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if I use the data validation method, how do I lay out the table of data??

    I would prefer to use "real" combo boxes.Would you be able to tell me how to do this method as well?
    thank you

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

    On 2002-02-17 07:20, Gurps wrote:
    if I use the data validation method, how do I lay out the table of data??

    I would prefer to use "real" combo boxes.Would you be able to tell me how to do this method as well?
    I don't believe the ComboBox would suit your purpose. The "Input range" appears not to like INDIRECT formulas.

    As Juan suggested, it's more convenient to use Lists thru data validation.

    The method is as follows:

    Enter in some column what follows:

    {"USA";"FRANCE"}[ That's, enter USA in a cell, then FRANCE in the next cell down ]

    Select these cells, go to the Name Box on the Formula Bar, and type COUNTRIES followed by enter.

    Enter in a column next to COUNTRIES:

    {"New York";"Pittsburgh";"Los Angeles";"Boston"}

    Name this range of cells USA via the Name Box as described above.

    Enter in a column next to USA:

    {"Paris";"Nice";"Toulon"}

    Name this range FRANCE.

    Just to see how this works,

    activate A1 in some worksheet in the same workbook;

    activate Data|Validation;

    choose 'List' for 'Allow';

    enter as 'Source' the formula:

    =COUNTRIES

    click OK;

    activate another cell in the same worksheet, say, C1;

    activate Data|Validation;

    choose 'List' for 'Allow';

    enter as 'Source' the formula:

    =INDIRECT(A1)

    click OK.

    Now you have two lists of which the 2nd depends on the selection from the 1st.

  5. #5
    Guest

    Default

    cheers mate for the help. I've got that working. Is there any way in which i can get the drop down arrows to stay there permanently? because i need a visible menu option.

    thanks again

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

    On 2002-02-17 10:32, Anonymous wrote:

    Is there any way in which i can get the drop down arrows to stay there permanently? because i need a visible menu option.
    As far as I know, there isn't a way to do it, unless someone can do it in VBA.

    It isn't much, but you can color the cells, put borders around them, etc. to make them stand out.

  7. #7
    Guest

    Default

    thanks for all your help!!!!! much appreciated!!

  8. #8
    Board Regular
    Join Date
    Jun 2002
    Posts
    207
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Man, that INDIRECT is ssssssweet!

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The indirect way is excellent..but now a poser say i choose from the first column usa and then a value )say 20) from the second..in the second worksheet I want the value to be subtracted from USA which is also in the second sheet..how??? col

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

      
    On 2002-08-28 22:03, colleen wrote:
    The indirect way is excellent..but now a poser say i choose from the first column usa and then a value )say 20) from the second..in the second worksheet I want the value to be subtracted from USA which is also in the second sheet..how??? col
    I don't think I understand... Care to elaborate a bit more?

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