Results 1 to 4 of 4

Thread: Cascading Combo Boxes
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2012
    Posts
    951
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cascading Combo Boxes

    I'm looking to create cascading combo boxes. I do not want data validation, only combo box.

    Essentially, I'm creating a dashboard based off a pivot table. I want to user to make selections on the Dash, and the PivotTable will adjust the report filters.

    I've got everything all linked up, the only issue is the dependent combo boxes.

    Ex.

    Select Region {Africa, Asia, Europe, North America,...}

    Depending on selection, Select Country [Africa] {South Africa, Congo, Egypt,...}

    Select City ...

    I've got a long bit of code that chops up data and creates named ranges/pivottables for everything. I'm just struggling on the cascading combo box since I can't use indirect().

    Does anyone have any suggestions or helpful links? I've googled this for the last day or so and come across nothing beneficial. Thank you for your help. Excel 2007.


    This was the most helpful link, but I don't want to use a userform - and "rowsource" isn't in the combobox properties.
    Cascading Combo Boxes in Excel (Part II) The Office Corner

  2. #2
    MrExcel MVP Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Cascading Combo Boxes

    On a worksheet a ComboBox's RowSource property becomes ListFillRange.
    Microsoft MVP - Excel

  3. #3
    Board Regular
    Join Date
    Mar 2012
    Posts
    951
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cascading Combo Boxes

    Thanks for the tip! I'll give it a try.

  4. #4
    Board Regular
    Join Date
    Mar 2012
    Posts
    951
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cascading Combo Boxes

    Quote Originally Posted by Andrew Poulsom View Post
    On a worksheet a ComboBox's RowSource property becomes ListFillRange.
    Thanks again, Andrew. Worked perfectly!

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
  •