sheetChange event and list validation
in Worksheet_Change sub-routine, i have certain cells change the interior
pattern whenever the column of the cell is let say 5. the cells in column 5
are list validation. when i change the value through the list it goes into
the code and goes thru the code correctly but the interior pattern did not
change. I am currently using windows XP Pro and office XP Pro. Thank you!
Nick
|