R Ricdel New Member Joined Dec 20, 2005 Messages 4 Dec 20, 2005 #1 Sorry if this is quite elementary. How do I run an existing macro when the value of a specific cell changes?
Sorry if this is quite elementary. How do I run an existing macro when the value of a specific cell changes?
C Crow_23 Board Regular Joined Feb 17, 2005 Messages 183 Dec 20, 2005 #2 Code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub
G GaryAtWork Board Regular Joined Dec 19, 2005 Messages 83 Dec 20, 2005 #3 Or maybe this in the code for the worksheet Code: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "SpecificCellAddress" Then MacroName Application.EnableEvents = True End Sub
Or maybe this in the code for the worksheet Code: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "SpecificCellAddress" Then MacroName Application.EnableEvents = True End Sub