Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation list does not trigger worksheet_change event | Excel Programming | |||
Problem with Data Validation Dropdown List / Worksheet_Change Event | Excel Programming | |||
Data Validation & Worksheet_change | Excel Programming | |||
clearcontents, worksheet_change, cell validation | Excel Programming | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming |