Combobox add item depending on previous cell

[antros48]

Hi all,
I have an excel sheet in the form of my attachment. The first column states the department (cbosubdivision), the second the job level (cbojoblevel) that could be on the same department more than once, and the third some kind of description (cbojobdescription). I have three comboboxes of which the first one shows on a drop down list unique data e.g. Department A, Department B. The second shows depending on the Department chosen, the various choices but only again in a unique drop down list e.g. A,B,C,D. The third combobox i would like it to show the corresponding choices for each of the previous choice, meaning if selected Department A and A, then the choices abc and sdr will be shown on the list of the third combobox to choose. I already found some scripts and applied them appropriately until the second dropbox, but on the third i cannot get it working..
Any help appreciated.

Please Login or Register  to view this content.

[antros48]

Any help....?

[bakerman2]

Which attachment....?

[antros48]

Sorry about that, i thought it uploaded..

[torachan]

Is this what you are wanting to achieve.
It is repetitive code on each combo-box.
Load an array, remove non-selections by setting values to "", then deleting, then load to 'collection' only uniques for next combo.
Repeat as many times as the number of cascading comboboxes.
torachan.

[bakerman2]

Another one using dictionaries.

Please Login or Register  to view this content.