VBA help need for linking three ActiveX Control ComboBoxes

[krjoshi]

Folks,

Please help me to link three ActiveX Control ComboBoxes. I have attached the work book of what I'm trying to accomplish.


Thanks in advance for your expertise!

[natefarm]

I added code to your sample and attached it below. FYI, there is code in Sheet1, ThisWorkbook, and Module1. The ThisWorkbook code is so the lists load automatically when the workbook is opened.

ComboBoxes.xlsm

To give credit where due, I got started with help from the following link. Note the reference to the Microsoft ActiveX Data Objects Library that you'll need to set: http://datapigtechnologies.com/blog/...unique-values/

Good luck!

[jaslake]

Hi Joshi

Unfortunately I can't give proper attribution...attached is an example File that demonstrates Dependant ActiveX ComboBoxes and may well be adaptable to your needs.

[krjoshi]

Natefarm and John,

Thank you so much. Both solutions are very good.

Joshi