cascading combo boxes...??? - Page 10
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Page 10 of 12 FirstFirst ... 89101112 LastLast
Results 91 to 100 of 116

Thread: cascading combo boxes...???

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

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

     
    What do you mean by this?
    What does the Reffering to box display?

    I won't be able to reply again for about 3 hours. TIA

    Is doing Name Define different to naming in the left hand cell at the top ie where the formulas etc show

  2. #92
    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 Vegemite Kid View Post
    What do you mean by this?
    What does the Reffering to box display?

    I won't be able to reply again for about 3 hours. TIA

    Is doing Name Define different to naming in the left hand cell at the top ie where the formulas etc show
    USA1a
    FRANCE2b
    3c
    FRANCEc


    Select B14:B15.
    Go to the Name Box on the Formula Bar, type COUNTRIES, and hit enter.
    Select C14:C15.
    Go to the Name Box on the Formula Bar, type USA, and hit enter.
    Select D14:D15.
    Go to the Name Box on the Formula Bar, type FRANCE, and hit enter.

    Select B19.
    Choose List for Allow.
    Enter

    =COUNTRIES

    in the Formula box.

    Select C19.
    Choose List for Allow.
    Enter

    =INDIRECT(B19)

    in the Formula box.
    Assuming too much and qualifying too much are two faces of the same problem.

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

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

    Thanks again for your help. Bizarrely, I've just made another Excel sheet and now it's working. But I still don't understand what I did wrong with the first one. I need to work out what I did wrong. There's no way to upload a file is there.

  4. #94
    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 Vegemite Kid View Post
    Thanks again for your help.
    You are welcome.

    Bizarrely, I've just made another Excel sheet and now it's working. But I still don't understand what I did wrong with the first one. I need to work out what I did wrong. There's no way to upload a file is there.
    No, uploading a file here is not possible.
    Assuming too much and qualifying too much are two faces of the same problem.

  5. #95
    New Member
    Join Date
    Feb 2010
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Ack I spoke too soon

    I've actually got three combo boxes in a row. I know it's a basic way of working and I need to improve my Excel skills dramatically but in the meantime...

    Though I have defined everything properly, (checked the name define) only one of the data values is coming up for the third column. No error message - just the data value. Any tips on what could cause that?

  6. #96
    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 Vegemite Kid View Post
    Ack I spoke too soon

    I've actually got three combo boxes in a row. I know it's a basic way of working and I need to improve my Excel skills dramatically but in the meantime...

    Though I have defined everything properly, (checked the name define) only one of the data values is coming up for the third column. No error message - just the data value. Any tips on what could cause that?
    Data|Validation (a) is a different beast than "combo boxes" (b). For (a), see my previous post. If that's what you want, try to follow the instructions to the letter. If (b) is your concern, have a look at posts in this thread which discuss the combo boxes.
    Assuming too much and qualifying too much are two faces of the same problem.

  7. #97
    New Member
    Join Date
    Feb 2010
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    I did follow it to the letter. I'd like to think I have a few brain cells so am guessing I need to get more familiar with data validation. Thanks again

  8. #98
    New Member
    Join Date
    May 2010
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: cascading combo boxes...???

    Can I add some more Kudos..! I had the same requirement of having a dependent list validation..and this works..!

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

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

    This is NICE!

    Is there any way to display an error message (if you click on the cell to select city, without having inputted country already) that goes something like (in line with the example above) "You Must First Select a Country"

    Thanks!

    EDIT: ooops, I only read the first page of this thread so this question might already be answered somewhere in here...

  10. #100
    Board Regular
    Join Date
    Mar 2010
    Posts
    90
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

      
    hey aladin y indirect doesnt work for no adjacent range or cell?y do we ve to write in same column or rows name like u gave example of USA and France?y indirect doesnt work>?

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