Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-17-2017, 01:19 AM
gmayor's Avatar
gmayor gmayor is offline Combining dropdown list VBA and data repeat VBA Windows 10 Combining dropdown list VBA and data repeat VBA Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining dropdown list VBA and data repeat VBA How do I make a checkbox or dropdown item reference data in that specific section of the data array? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft