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
mrbalaje wrote:
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.
----== Posted via Pronews.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.pronews.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= - Total Privacy via Encryption =---