Dropdown dependencies with multiple dropdowns

LaurenM · #3 11-22-2017, 12:08 AM

Thank you Macropod

At the moment I have this:

Code:

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Dim i As Long, StrDetails As String
With ContentControl
  If .Title = "CHOOSE SECTOR" 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
    TextBoxLauren.Text = StrDetails
   ElseIf .Title = "CHOOSE SECTOR XHO" 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
    TextBoxLauren.Text = StrDetails
    Else
End If

End With

End Sub

I also need to lock the previous outputs so that if the sector changes mid report (in a new section) the previous outputs will remain unchanged. I hope this makes sense. Thank you in anticipation.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple entries in dropdown lists	paul_pearson	Word VBA	151	10-18-2023 04:23 PM
Multiple Selection Dropdown list	ajanson	Word VBA	36	07-15-2019 08:16 PM
Dropdown boxes to multiple fields?	Nukedaddy	Word	3	09-16-2016 06:50 AM
Content Control Dropdown Dependencies	asteinroeder	Word VBA	5	10-28-2015 03:56 PM
Multiple resource Dependencies / Mapping	Sherry	Project	3	04-03-2014 08:03 AM