Worksheet_Change fires even when no change?

[PhilipPosting]

Hi,
I have set Worksheet_Change up OK for a sheet, so it is called
whenever a value changes. The problem is that it gets called even if
a value does not change. So, for example, if I have 7 in cell A1, and
then retype 7 in A1, Worksheet_Change is called, although no value
changed in the worksheet. Is this the way Worksheet_Change works? Is
there a way to change it? Failing that, is there a way I can tell
once I'm in Worksheet_Change that the change was not really a change?

Thanks in advance,
Philip.

 

[Leith Ross]

Hi,
I have set Worksheet_Change up OK for a sheet, so it is called
whenever a value changes. The problem is that it gets called even if
a value does not change. So, for example, if I have 7 in cell A1, and
then retype 7 in A1, Worksheet_Change is called, although no value
changed in the worksheet. Is this the way Worksheet_Change works? Is
there a way to change it? Failing that, is there a way I can tell
once I'm in Worksheet_Change that the change was not really a change?

Thanks in advance,
Philip.

Hello Philip,

Worksheet_Change fires whenever a cell's value changes, either by the
user or external link. Worksheet_SelectionChange fires whenever you a
cell is selected

Sincerely,
Leith Ross.

 

[PhilipPosting]

Hi Leith,
The thing I'm seeing is that Worksheet_Change fires even if the
cell's value does *not* change. i.e. I just retype the existing value
in the cell. Does that happen for you, or if you retype the same
value in a cell, do you not fire Worksheet_Change?

Philip.

 

[Chip Pearson]

Nowhere is the previous value of a cell preserved, in respect to the Change
event. The event will trigger whenever you edit the cell and press ENTER.
Even if you type in the same value as the cell contains, it is still
considered a Change with respect to the event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)