I found this
thread, but can't figure out two things.
1) How to edit this code for only one additional entry
2) How to know the index number of a control
In the first dropdown, there are only be two variables: 150.7 and 185
If 150.7 is selected, I want the other dropdown to read 1.077
If 185 is selected, I need the other dropdown to read 1.044
I have set the first dropdown with the display name as 150.7 and the value as 1.077, but can't figure out adjusting the code below to not need the Replace part.
I'm using content control instead of form fields because I read they don't play well together. Also, there are many other content controls on this doc.
The code runs fine with the loop, but not really needing the loop and figuring out the index of the content control.
Code:
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.ContentControls(2).Range.Text = StrDetails
End If
End With
End Sub