Detecting changes

[Mileshigh]

Is there a way to have vba detect if changes have been made so that a msgbox can prompt the user to accept or decline changes made?

 

[doofusboy]

Yep, just use the following to add your code for what changes to watch for and what to do when they happen.

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub

 

[Mileshigh]

Any place in general or am i call this a sub?