![]() |
|
#1
|
|||
|
|||
![]()
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 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. |
![]() |
|
![]() |
||||
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 |
![]() |
BoringDavid | Word VBA | 5 | 05-09-2014 09:08 AM |
![]() |
SuzeG | Word VBA | 4 | 12-17-2013 03:40 PM |
![]() |
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 |