What if the user changes the value but then changes it back to the orginal
(default) value ?
Would you still want to log that ?

Tim


"aga2957" wrote in
message ...

I have an excel sheet that I designed to look like a form. That form has
default values. Now, what I want to do is that, whenever there is a
change in any cell, let's say for example, someone change the value of
A4, that change will be recorded in C5 for example.

Let's have a working example,

A4 default value = 5

When someone change the value of A4, C5 will show A4. Meaning, A4 has
been changed.

So goes with other cells with default values.

Let's say for example, the value of A5 has been changed, then C5 will
now show "A4, A5" meaning, these cells were changed.

Thank you so much for your assistance!


--
aga2957
------------------------------------------------------------------------
aga2957's Profile:
http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=573561