run a macro when D3 or E3 value changes

[Leighton Durham]

hello i need to program my sheet to run a macro called "clear" as soon as D3 or E3 change there value

 

[CeceR]

You can use the Worksheet Change code and use an If statement on Target.Address:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$D$3" Or Target.Address = "$E$3" Then

Call Clear

End If

End Sub