What's the syntax for executing a macro everytime a different cell gets focus ? thanks
K k483 Jul 2, 2004 #1 What's the syntax for executing a macro everytime a different cell gets focus ? thanks
J jeff Jul 2, 2004 #2 HI, Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Application.Intersect(Range("C4:C4"), Target) Is Nothing Then runMyMacro End Sub jeff
HI, Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Application.Intersect(Range("C4:C4"), Target) Is Nothing Then runMyMacro End Sub jeff
