I came across a wonderful framework for creating dependent combo boxes using class collection, where each class has an array. Ref: Dependent ComboBoxes with arrays in class collection| Excel VBA (sitestory.dk).
I am wanting to expand this framework to create 5 levels of cascading, assuming that as many arrays can be included in the class collection. But I am unable to figure out how to achieve this.
(I also contacted the author (email in the Contact menu on the link above) but he is retired and unable to help.)
Can I pl request guidance from the experts.
The link above includes a workbook.
I am wanting to expand this framework to create 5 levels of cascading, assuming that as many arrays can be included in the class collection. But I am unable to figure out how to achieve this.
(I also contacted the author (email in the Contact menu on the link above) but he is retired and unable to help.)
Can I pl request guidance from the experts.
The link above includes a workbook.
