Change event occurs
Excel & Windows XP
The following simple Change event macro fires if the active cell is blank and I hit the Delete key. Since no change to the contents of the cell occurred, why does it fire? Thanks for your help. Otto Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "It changed." End Sub |
Change event occurs
Otto Moehrbach wrote: Excel & Windows XP The following simple Change event macro fires if the active cell is blank and I hit the Delete key. Since no change to the contents of the cell occurred, why does it fire? Thanks for your help. Otto Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "It changed." End Sub Presumably because Change is fired on any assignment - even if the assignment was not a genuine change. If you have a cell containing say 5 and you enter 5 in that cell, it would also fire. There would be a definite overhead in comparing the old value and the new value of a range before firing the event. In the off-hand chance you want the event to fire only in the event of an actual change you could mimic this in code by storing the old data (maybe by having the selection change event write it to a public variable) and then compare it at the start of the change event, terminating the call if the values are the same. Hope that helps -John Coleman |
Change event occurs
Thanks John. Otto
"John Coleman" wrote in message oups.com... Otto Moehrbach wrote: Excel & Windows XP The following simple Change event macro fires if the active cell is blank and I hit the Delete key. Since no change to the contents of the cell occurred, why does it fire? Thanks for your help. Otto Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "It changed." End Sub Presumably because Change is fired on any assignment - even if the assignment was not a genuine change. If you have a cell containing say 5 and you enter 5 in that cell, it would also fire. There would be a definite overhead in comparing the old value and the new value of a range before firing the event. In the off-hand chance you want the event to fire only in the event of an actual change you could mimic this in code by storing the old data (maybe by having the selection change event write it to a public variable) and then compare it at the start of the change event, terminating the call if the values are the same. Hope that helps -John Coleman |
All times are GMT +1. The time now is 11:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com