![]() |
|
|
|
#1
|
||||
|
||||
|
Updated. Try it now.
Quote:
Code:
Sub BulkUpdateTutor()
Dim i As Long, j As Long, OldTutor As String, NewTutor As String
OldTutor = Trim(InputBox("Old Tutor"))
NewTutor = Trim(InputBox("New Tutor", , OldTutor))
If OldTutor = "" Then Exit Sub
With ActiveDocument
For i = 1 To .SelectContentControlsByTitle("Subject").Count
With .SelectContentControlsByTag("Subject_" & i)(1)
For j = 1 To .DropdownListEntries.Count
With .DropdownListEntries(j)
If Trim(.Value) = OldTutor Then
.Value = Replace(.Value, OldTutor, NewTutor)
End If
End With
Next
End With
Next
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Content Controls - Dependent Dropdown
|
someazguy | Word VBA | 14 | 02-05-2023 08:01 PM |
Multiple dependent dropdown lists in table with add new row option
|
jeweldarby | Word VBA | 6 | 05-21-2022 04:37 PM |
Dependent dropdown and repeat section
|
NLJ | Word VBA | 3 | 01-12-2020 05:00 PM |
Dropdown Menu Dependent on a Previous Drop Down
|
lgsikaffy | Word VBA | 3 | 12-14-2018 05:14 PM |
| Dropdown dependent text | JakeLRL | Word VBA | 7 | 04-07-2016 08:26 AM |