![]() |
|
#14
|
||||
|
||||
|
Setting the background colour relies heavily on the pattern you have applied to the cell. It would be simpler to set the foreground colour instead. Since the code chooses the cell based on the location of the CC, you can treat both CCs the same way
Code:
Private Sub Document_ContentControlOnExit(ByVal aCC As ContentControl, Cancel As Boolean)
Dim StrPwd As String, iCol As Long
StrPwd = "DocumentPassword"
With aCC
Select Case .Title
Case "Lst1", "Lst2"
'MsgBox .Range.Text
Select Case .Range.Text
Case "High"
iCol = wdRed
Case "Medium"
iCol = wdYellow
Case "Low"
iCol = wdBrightGreen
Case Else
iCol = wdWhite
End Select
If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect Password:=StrPwd
.Range.Cells(1).Shading.ForegroundPatternColorIndex = iCol
ActiveDocument.Protect wdAllowOnlyFormFields, True, StrPwd
End Select
End With
End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
| 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 |