![]() |
|
#18
|
||||
|
||||
|
To colour the text & background so they're the same, you could use:
Code:
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Const StrPwd As String = "abc"
With ContentControl
Select Case .Title
Case "Lst1", "Lst2"
If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect Password:=StrPwd
With .Range
Select Case .Text
Case "High"
.Cells(1).Shading.BackgroundPatternColorIndex = wdRed
.Font.ColorIndex = wdRed
Case "Medium"
.Cells(1).Shading.BackgroundPatternColorIndex = wdYellow
.Font.ColorIndex = wdYellow
Case "Low"
.Cells(1).Shading.BackgroundPatternColorIndex = wdBrightGreen
.Font.ColorIndex = wdBrightGreen
Case Else
.Cells(1).Shading.BackgroundPatternColorIndex = wdNoHighlight
.Font.ColorIndex = wdAuto
End Select
End With
ActiveDocument.Protect wdAllowOnlyFormFields, True, StrPwd
End Select
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| color, dropdown, reaction |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| block selection in dropdown list | Intruder | Excel | 2 | 01-10-2013 10:20 AM |
Dropdown selection value
|
coconutt | Word VBA | 5 | 09-13-2012 05:23 PM |
Change cell color when selection is made from a drop down list
|
fedcco | Excel | 12 | 08-28-2012 10:43 PM |
Autofill a form which is contingent on a dropdown selection.
|
biffle0764 | Word | 2 | 05-09-2012 12:54 PM |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |