I've looked over all this thread and think the solution is growing in complexity with considerable repetitive code to still be written.
I suggest taking a reset and look at this from a different perspective. Attached is an example which aligns with what I think the OP wanted. It avoids the userform in favour of mapped Content Controls and either CC properties or macros to populate the CC values.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|