Worksheet_Change after validation
I set up a Worksheet_Change event so as to change the background color of a
row relevant to the value of the column C cell (True/False). It works after
manually changing the values in Column C.
Following ND Pard's advice I managed to set up Data Validation in the C
Column cells so as to restrict entry to True/False. This works.
The problem is that InCell DropDown Validation does not seem to trigger the
Worksheet_Change event and the row background color does not reflect the
value change anymore.
Is this standard behaviour or am I doing something wrong? If it is standard,
where should I code the background change mechanism so that it works?
|