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

[Ai_Jun_Zhang]

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.

[Jim Thomlinson]

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
>
>

[Ai_Jun_Zhang]

Thanks, Jim.

I will give a try following your advise.

Thanks,

Aijun.