I have a spreadsheet that populates a form already created in Word.
I am populating content controls via the method below..

With wordapp.ActiveDocument
.SelectContentControlsByTitle("RFC").Item(1).Range.Text = Cells(Row.Row, 7).Value
End With

This work fine, but fails when attempting to populate a contentcontrol dropdown list.


With wordapp.ActiveDocument
.SelectContentControlsByTitle("RFC").Item(1).Range.Text = Cells(Row.Row, 7).Value
.SelectContentControlsByTitle("SRFC").Item(1).Range.Text = Cells(Row.Row, 6).Value
End With

The code in red does not work.
the value in Cells(Row.Row, 6).Value is one of the selections in the drop down list.

Has anyone been able to populate a contentcontrol dropdownlist based off of a value in a spreadsheet?