View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shiro[_2_] shiro[_2_] is offline
external usenet poster
 
Posts: 28
Default compare oldvalue and new value of a cell

Hi All,
how to write a code to compare the value of a cell
before it's being updated by user.If the new value
is different with the new value,I want the cell
background colour become different.But since
I have many sheet in my workbook,I want the code
become public and I try to keep the sheet clean
from any vba code.
Thank's

Shiro