Popup message when value changes
 

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.

Popup message when value changes
 

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.

Popup message when value changes
 

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.

Popup message when value changes
 

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