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.

Attached Files

lesson_plan.docm (78.6 KB, 11 views)

Just copy and paste them and see code in attached.

Attached Files

lesson_plan.docm (102.2 KB, 13 views)

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

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?