Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Foiled by Delete!
I use the following code to run a macro called "UpdateE5" whenever cell E4 is edited. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E4")) Is Nothing Then If Range("E4").Value < gOldE4 Then gOldE4 = Range("E4").Value Application.Run "UpdateE5" End If End If End Sub It works for any change in cell E4 except when that change is brought about by the use of the Delete key. ie, select cell E4, hit Delete, and pooh! Nothing! Is this possible to overcome? Regards - Dave B. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What version are you using? Works for me....XL2002SP3 & XP
Why not use If Target.Address instead of Intersect? OJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running macro from currently selected cell? | Excel Discussion (Misc queries) | |||
Running Macro when a cell value changes | Excel Discussion (Misc queries) | |||
programmatically changing priority of running excel macro at runti | Excel Programming | |||
Running macro when changing data | Excel Programming | |||
Running a macro when a cell value changes | Excel Programming |