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.
Bookmarks