Restrict comboBox list to relevant dictionary items

[nigelog]

I am beginning to understand the usefulness of dictionarys in vba and am trying to get a better understanding of the concepts.

With code posted below earlier by Fluff13,

https://www.excelforum.com/excel-pro...d-to-long.html

I was trying to created "cascaded" combobox entries but cannot work out how to get the filtered relevant items to display in combobox2. Combobox2 if selected does work as required an combobox3

The attached workbook will be self evident if someone wants to have a look at. Any help appreciated

[CK76]

Should this be one directional?
i.e. Combobox2 is only filled after Combobox1 change, and Combobox3 is only filled after Combobox2 change.

Or multi directional? Meaning change in any of the combobox will change available list in the other 2 (if not already selected).

[nigelog]

Should this be one directional?
i.e. Combobox2 is only filled after Combobox1 change, and Combobox3 is only filled after Combobox2 change.

Or multi directional? Meaning change in any of the combobox will change available list in the other 2 (if not already selected).

Hi

I think one directional would be great until I get the hang of the concept...

[CK76]

Then I'd do it like below.

Please Login or Register  to view this content.

[Fluff13]

Another option

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[nigelog]

Many thanks for the replies I will study the different options.. all no doubt work and will help me get to grips with dictionaries

I will post as solved