VBA to Populate text content controls in word from excel

lmoir87 · #1 07-31-2019, 04:09 AM

Hi

I am trying to populate a word document with named ranges/cells in an excel template.

My first iteration was using 'Label' and i was able to get these to populate as follows;

Code:

ThisDocument.Label1.Caption=workbook.Sheets("Sheet1").Range("Label1)

However, I would prefer to use a Rich Text content control, so that the formatting matches the document and so it is possible to click into the content control after it has been populated.

Thanks
LM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Content Controls for large quantities of text	tonia8675309	Word	5	06-08-2018 04:42 PM
Populate Content Control Dropdowns from Excel	Deirdre Kelly	Word VBA	23	09-07-2017 02:51 PM
Rich text/Plain text Content Controls in Template	michael.fisher5	Word	9	11-19-2014 06:36 AM
Moving between Rich text content controls	Sammie0Sue	Word	4	03-12-2014 01:43 AM
Rich Text Content Controls: Formatting?	tinfanide	Word VBA	8	03-04-2013 04:15 AM