VBA to Populate text content controls in word from excel

gmayor · #1 08-01-2019, 08:35 PM

You can loop through all the controls and apply the appropriate value from the worksheet to the titled control e.g. as follows. You are still going to have to associate 30 titles with the 30 Excel cells

Code:

Dim oCC As ContentControl
    For Each oCC In ActiveDocument.ContentControls
        Select Case oCC.TITLE
            Case "title of control 1"
                oCC.Range.Text = whatever
            Case "title of control 2"
                oCC.Range.Text = whatever
            Case "title of control 3"
                oCC.Range.Text = whatever
                'etc
        End Select
    Next oCC

lmoir87 · #2 08-05-2019, 07:11 AM

Thank you. This works great.

rtodd.larsen · #3 10-02-2020, 09:36 AM

Gmayor,

You posted a way to insert text into a rich content control. Is there a way to insert an image of an Excel table into a rich content control. I can't figure out the how I would need to change what you indicated for text for an image. I would really appreciate the help.

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