View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aga2957[_5_] aga2957[_5_] is offline
external usenet poster
 
Posts: 1
Default Detect Cell Changes


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