![]() |
|
#4
|
||||
|
||||
|
You could use a ContentControlOnExit macro in the 'ThisDocument' code module of the document or its template, coded like:
Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)
Dim i As Long
With CCtrl
If .Title = "Master" Then
If .Range.Text = "N/A" Then
For i = 1 To 2
With ActiveDocument.SelectContentControlsByTitle("Slave")(i)
.Type = wdContentControlText
.Range.Text = "N/A"
.LockContents = True
End With
Next
Else
For i = 1 To 2
With ActiveDocument.SelectContentControlsByTitle("Slave")(i)
If .Type = wdContentControlText Then
.LockContents = False
.Range.Text = ""
.Type = wdContentControlDropdownList
End If
End With
Next
End If
End If
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Help with cascading dropdown list
|
SaraO | Word VBA | 43 | 01-25-2023 04:05 PM |
| Userform with Multiple Cascading Drop Down Lists Populated with External Source Data | venganewt | Word VBA | 21 | 05-16-2018 02:05 PM |
Cascading List Word 2010
|
Marvel | Word VBA | 11 | 05-14-2016 02:08 AM |
Issue Using Word Document with Cascading Drop Down Lists
|
LynnMac2016 | Word VBA | 3 | 04-06-2016 06:15 AM |
How to update cascading styles?
|
mmmb | Word | 3 | 01-21-2016 07:08 PM |