LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Worksheet_Change fires even when no change?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Capture Cell Value Before Change Event Fires? MVP Wannabe Excel Programming 2 June 28th 07 09:16 PM
Change event on single cell fires many times XP Excel Programming 3 November 6th 06 10:16 PM
worksheet_change event fires multiple times timconstan[_3_] Excel Programming 0 October 6th 04 03:59 PM
worksheet_change event fires multiple times timconstan[_2_] Excel Programming 1 October 5th 04 07:44 PM
worksheet_change event fires multiple times timconstan Excel Programming 1 October 5th 04 05:55 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"