Thanks Macropod, you guys are amazing at the time and help you provide.
Yes, I did read further in the post and I am currently including the two columns like you mentioned, only modified for columns B and C like below.
Code:
ActiveDocument.ContentControls(1).DropdownListEntries.Add Trim(.Range("B" & i)), Trim(.Range("C" & i))
And when I view the properties of the CC, I see both the Display Name and Value correctly.
And then learning about the ControlOnExit, the dropdown shows the Display Names, and then changes to the value on Exit of the CC.
But I'm currently stuck at getting that value to actually display as a FieldCode Link Source. I've tried adding the { } to the cell range to no luck and still displays a text.. So believe I need to somehow modify the VBA to insert CC value as link field code?
My Word document currently has about 60 chartlinks in the document. And as user incorrectly deletes them (which they will do!!), I'm trying to provide a way for the user to choose from a list and reinsert a linked chart.