View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nick nick is offline
external usenet poster
 
Posts: 192
Default 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