thank you very much. it is very useful. In fact, the problem I have i
more generel. Let's say, for the first colum(A), I have 10 numbers. Fo
the second colum(B), I have another 10 numbers. The third colum is th
formula of sum of the corresponding cells in first two colum. For th
thrid colum, I need the following functionality, for example, fo
Cells(3,1),

Once I change the formula in Cells(3,1), the color of the cel
Cells(3,1) should be changed.
Once I double click the changed cell Cells(3,1), it should recover t
the formula “=SUM(A1+B1)”.

Thank you again for your hel

--
jaccke
-----------------------------------------------------------------------
jaccker's Profile: http://www.excelforum.com/member.php...fo&userid=3311
View this thread: http://www.excelforum.com/showthread.php?threadid=52922