I doubt it. Your code looks rather more like something you've cobbled together from various posts here - mine, especially.

For Content Control population from Excel, see:
https://www.msofficeforums.com/word-...drop-down.html
https://www.msofficeforums.com/word-...wns-excel.html

And, for Dependent Dropdown Content Controls, see:
https://www.msofficeforums.com/word-...html#post77762

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]