how to add same dropdown list on the same document

[ryanne]

Hi! Its my first time to use macro and with the help of the posts here, I successfully created (or copied) cascading dropdown list (after several tries).



And now the problem is this, i wanted to copy the same cascading drop down list in another four columns but I cannot find the solution to this. I am referring to the teaching approach and strategy section to be copied on the next four columns.


I have attached the file for your reference.


Please help me.

Thanks.

[gmaxey]

Just copy and paste them and see code in attached.

[ryanne]

thanks so much!

by the way if ever i need to add another cascading drop down list but its a different list this time, would that be possible?