Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How Capture Cell Value Before Change Event Fires? | Excel Programming | |||
Change event on single cell fires many times | Excel Programming | |||
worksheet_change event fires multiple times | Excel Programming | |||
worksheet_change event fires multiple times | Excel Programming | |||
worksheet_change event fires multiple times | Excel Programming |