Hi,
I have a content control dropdown list with few entries.How to copy/mirror the Display Name of entry (not value) from dropdown list to various other plain text content controls within the document. I mean when I select an entry from Dropdown list CC, want the same entry to be displayed in 2 other plain text CC.
Tried out document property method and OLE link method as described https://gregmaxey.com/word_tip_pages...ting_data.html by Mr. Maxey. But Document property method does not allow CC. And the OLE method requires the links in document to updated every time when there is a selection change in dropdown.
So how to mirror dropdown selection to various plain text controls using vba.
I am using the following code to display the value (but not Display Name) of selected entry in a plain text content control.
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Dim i As Long, StrDetails As String
With ContentControl
If .Title = "Client" Then
For i = 1 To .DropdownListEntries.Count
If .DropdownListEntries(i).Text = .Range.Text Then
StrDetails = Replace(.DropdownListEntries(i).Value, "|", Chr(11))
Exit For
End If
Next
ActiveDocument.SelectContentControlsByTitle("ClientDetails").Item(1).Range.Text = StrDetails
End If
End With
End Sub
Bookmarks