Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 12 of 12 FirstFirst ... 2101112
Results 111 to 116 of 116

Thread: cascading combo boxes...???

  1. #111
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

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

    Quote Originally Posted by greenie532 View Post
    This is the list in B2
    PS3list
    Wii
    PC
    XBOX
    DS
    Accessories
    Consoles


    These correspond to the sheet names in the work book, each sheet has has each sheet has 4 columns; A=Product Code, B=Description, C=Qty, D=Price.
    Right.

    On another sheet, cell B2 brings up the list above, cell C2 has data validation as "List" and source as "=Indirect(B2) which gives the list of product codes for the selection in B2. What I would like to do is bring the cost over at the same time. Hope this makes sense.
    Another B2 with the same list of the sheet names... However, I don't understand, how you get a list of product codes with:

    =INDIRECT(B2)

    for B2 just is a sheet name.
    Assuming too much and qualifying too much are two faces of the same problem.

  2. #112
    New Member
    Join Date
    Oct 2010
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    I'm not explaining this very well, can I post the spreadsheet on this site ?

  3. #113
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    38,065
    Post Thanks / Like
    Mentioned
    63 Post(s)
    Tagged
    12 Thread(s)

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

    Quote Originally Posted by greenie532 View Post
    I'm not explaining this very well, can I post the spreadsheet on this site ?
    You cannot attach an actual file but you can post small screen shots. Here is a few ways to investigate:

    Excel jeanie
    or
    RichardSchollarís beta HTML Maker - see the red text in his signature block at the bottom of his post
    or
    Borders-Copy-Paste
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

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

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

    This process allows for each selection to be shown in separate columns. If I want to use nested dropdowns where the first dropdown links to a second (and/or third as needed) AND the final selection is what shows up in the cell; is this possible and if so, how?

    e.g.: I select A1 which brings up menu "Countries." I select "England" which brings up 'Cities.' I select "London" and this is placed in cell A1.

  5. #115
    New Member
    Join Date
    Jul 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    That was gr8. Thax dear.

  6. #116
    Board Regular proficient's Avatar
    Join Date
    Apr 2012
    Location
    Karachi, Pakistan.
    Posts
    697
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

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

    Aladin!

    You are awesome
    Regards,

    Kamran Mumtaz
    PAKISTAN.

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    Playing with excel -
    2007

    Want to post a small screen shot? Try this Excel jeanie,

    Try searching for your answer first, see how

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
  •