+ Reply to Thread
Results 1 to 9 of 9

Multiple Cascading Comboxes in Userform

  1. #1
    Registered User
    Join Date
    05-18-2011
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Multiple Cascading Comboxes in Userform

    Hi everyone. I'm trying to setup multiple cascading comboboxes in a userform. I've been able to get combobox2 to show the relevant managers for the selected entity in combobox1 (example: if I select Entity 4, it should display Apple and Cash & Equivalent in Combobox2). However, I would like for combobox3 to display the relevant ID when I select Apple in combobox2 (ID = 1449628). Right now, when I select Apple it shows both ID's for Entity 4. However, in the event that an entity has multiple holdings of a manager (Example: entity 3 has two managers for SPDR S&P 500 ETF), I would like for it to show both ID's in combobox3.

    Any help is greatly appreciated.

    Entity-ID-Manager
    Entity 4 - 1449628 - Apple
    Entity 4 - 1541836 - Cash & Equivalent
    Entity 3 - 1597261 - Cash & Equivalent
    Entity 3 - 1440081 - Berkshire Hathaway



    Please Login or Register  to view this content.
    Last edited by Jbryce22; 03-23-2012 at 04:32 PM.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Multiple Cascading Comboxes in Userform

    Post the workbook, save us creating data.

  3. #3
    Registered User
    Join Date
    05-18-2011
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Multiple Cascading Comboxes in Userform

    Here is the workbook.

    Multiple Cascading Comboboxes.xlsm

  4. #4
    Registered User
    Join Date
    05-18-2011
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Multiple Cascading Comboxes in Userform

    Bob, any thoughts on this?

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiple Cascading Comboxes in Userform

    Hi Jbryce22
    Try this code for your ComboBox2 Change Event
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  6. #6
    Registered User
    Join Date
    05-18-2011
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Multiple Cascading Comboxes in Userform

    Jaslake, that gets me really close. The only thing it is not doing is displaying ever associated ID with the defined security. For instance, in entity 3, SPDR S&P 500 ETF has two ID's (1497420 and 1647604). It is displaying the first ID, but not the second. I would hope that it would grab the second one and include it as well. I'm not sure if this is even possible?

    Thanks a lot for all of the help. It is greatly appreciated.

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiple Cascading Comboxes in Userform

    Hi Jbryce22
    Sorry, didn't notice that...try this instead. Let me know of issues.
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    05-18-2011
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Multiple Cascading Comboxes in Userform

    Jaslake, You are the man! Thanks tons!

  9. #9
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiple Cascading Comboxes in Userform

    Hi Jbryce22
    You're welcome...glad I could help. Thanks for the style points.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1