![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
block selection in dropdown list | Intruder | Excel | 2 | 01-10-2013 10:20 AM |
![]() |
coconutt | Word VBA | 5 | 09-13-2012 05:23 PM |
![]() |
fedcco | Excel | 12 | 08-28-2012 10:43 PM |
![]() |
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 |