Create UserForm ComboBox or ContentControl

ptmuldoon · #1 01-14-2015, 06:21 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code in a UserForm module to delete a Command Button which opens the userform	Simoninparis	Word VBA	2	09-21-2014 03:50 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM
Trying to Reference a ContentControl Using DocProperty	SuzeG	Word VBA	4	12-17-2013 03:40 PM
Activate/ select ContentControl	czsti	Word VBA	1	08-14-2013 08:32 AM
ComboBox ListIndex = -1 even though it does NOT = -1	Joe Patrick	Word VBA	0	08-03-2011 08:34 AM