Popup message when value changes

[mrbalaje]

Hello,

I need a code which can alert me with a message box when the value of the
cell changes from "OK" to "CHECK". Can anyone help me.

 

[Mike H]

Hi,

Which cell and what changes it to either of those values?

Mike

 

[mrbalaje]

Hello Mike,

Let say cell "D5" and only when it becomes "CHECK", I need a popup message.

 

[Dave D-C]

This may be a start:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Rows.Count <> 1 Then Exit Sub
If Target.Columns.Count <> 1 Then Exit Sub
' if target.row .. ?
' if target.Column .. ?
If Target.Value = "CHECK" Then
MsgBox "You don't want that in " & Target.Address
End If
End Sub ' Dave D-C