Dynamic Dependent ActiveX Dropdown from Column Data

[Mani_bbc05]

Hi Friends,

I need your help in creating 3 ActiveX ComboBox with dynamic drop down List Range which should be interdependent on each other.

I have attached a test file, with notes which i have to follow while creating the Comboboxes.

10941


Thanks & Regards

[Kenneth Hobs]

Welcome to the forum!

Looks like a homework problem.

I see 1>2>3 as the order to drill down through the lists. I don't see a way to do that and an order like 2>1>3 and/or 2>3>1 or other combinations.

It might be best to have a reset button and then restart drilling. A reset could clear the lists allow some other drilling or drilling scenario.