Use the Worksheet_Change event within that sheets module.Private Sub Worksheet_Change(ByVal Target As Range)'Your Code Here'End Sub