Popup message when value changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrbalaje - 21 Mar 2008 08:19 GMT

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.

Reply to this Message

Mike H - 21 Mar 2008 11:07 GMT

Hi,

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

Mike

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

Reply to this Message

mrbalaje - 22 Mar 2008 03:59 GMT

Hello Mike,

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

> Hi,
>
[quoted text clipped - 6 lines]
> > 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.

Reply to this Message

Dave D-C - 22 Mar 2008 17:54 GMT

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

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

Reply to this Message