Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Something just changed, time to act!"
End Sub

or

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "A new cell has been selected, maybe act here?"
End Sub

One of the two is bound to be what you are after...