Worksheet Change Event

Syntax

Private Sub Worksheet_Change(ByVal Target As Range)

Enter Code

End Sub

This event occurs when cells on the worksheet are changed by the user or by an external link.