![]() |
#2
|
||||
|
||||
![]()
That's fairly straightforward as you have done all the work
Code:
Option Explicit Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean) Dim i As Integer Dim strDetails As String With ActiveDocument 'Use the Select Case only if employing Custom Document Properties Select Case ContentControl.Title Case "Sbjct": .CustomDocumentProperties("Sbjct").Value = ContentControl.Range.Text Case "Stmnt": .CustomDocumentProperties("Stmnt").Value = ContentControl.Range.Text Case "Dsclr": .CustomDocumentProperties("Dsclr").Value = ContentControl.Range.Text Case "MjTpc": .CustomDocumentProperties("MjTpc").Value = ContentControl.Range.Text Case "ClientA" For i = 1 To ContentControl.DropdownListEntries.Count If ContentControl.DropdownListEntries(i).Text = ContentControl.Range.Text Then strDetails = Replace(ContentControl.DropdownListEntries(i).Value, "|", Chr(11)) Exit For End If Next With ActiveDocument.SelectContentControlsByTitle("ClientDetailsA")(1) .LockContents = False .Range.Text = strDetails .LockContents = True End With Case "ClientB" For i = 1 To ContentControl.DropdownListEntries.Count If ContentControl.DropdownListEntries(i).Text = ContentControl.Range.Text Then strDetails = Replace(ContentControl.DropdownListEntries(i).Value, "|", Chr(11)) Exit For End If Next With ActiveDocument.SelectContentControlsByTitle("ClientDetailsB")(1) .LockContents = False .Range.Text = strDetails .LockContents = True End With End Select .Fields.Update End With End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dhare | Excel Programming | 2 | 02-24-2016 12:36 PM |
Help!! Dropdown List | christo16 | Word | 1 | 06-29-2015 05:18 AM |
combining 2 or more columns of numerical data or text data | heartdoc | Excel | 0 | 12-03-2014 10:57 PM |
Populate dropdown list with data from Access table | spw4000 | Office | 0 | 02-24-2012 05:22 AM |
Using fields to repeat data throughout a document | Brasada | Word | 0 | 07-20-2010 02:37 PM |