How to detect if there is change in any cell vlaue in a worksheet?
 

Hi!

I know worksheet_change can dectec that a change in a worksheet. But in
my case if I change a cell from 20 to 20, it should not be a change
because they are the same value. Can I know how I detect a real change
in cell value in a worksheet? That is how do I detect there is a change
in any cell in a worksheet that the new value is different from the
previous value?

Please advise.

Aijun.


--
Ai_Jun_Zhang
------------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474
View this thread: http://www.excelforum.com/showthread...hreadid=468914

How to detect if there is change in any cell vlaue in a worksheet?
 

You can use the selection change and sheet activate events to capture the
value of the active cell when the sheet is first accessed or the acitve cell
is changed. Store this value in a global variable and compare it to the value
of the changed cell to determine if the value really changed.
--
HTH...

Jim Thomlinson


"Ai_Jun_Zhang" wrote:


Hi!

I know worksheet_change can dectec that a change in a worksheet. But in
my case if I change a cell from 20 to 20, it should not be a change
because they are the same value. Can I know how I detect a real change
in cell value in a worksheet? That is how do I detect there is a change
in any cell in a worksheet that the new value is different from the
previous value?

Please advise.

Aijun.


--
Ai_Jun_Zhang
------------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474
View this thread: http://www.excelforum.com/showthread...hreadid=468914

How to detect if there is change in any cell vlaue in a worksheet?
 

Thanks, Jim.

I will give a try following your advise.

Thanks,

Aijun

--
Ai_Jun_Zhan
-----------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...fo&userid=2547
View this thread: http://www.excelforum.com/showthread.php?threadid=46891