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.

Hi,

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

Mike

"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.

Hello Mike,

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

"Mike H" wrote:

Hi,

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

Mike

"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.

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 =---