Worksheet Change Event

Dear Gurus,

i have question, can a macro be run if a particular cell value would be changed?


for instance Cell A2 Value is = Interim Report and if the value is changed to Final Report then a macro should run for instance a msgbox to pop "Text Changed"

would this be possible?


thanks.

Step1:- Right click on sheet1 tab and click on View code
Step2:- Paste below code

Code:

---


        Private Sub Worksheet_Change(ByVal Target As Range)
       
            If Target.Address(0, 0) = "A2" Then
                MsgBox "Text changed.", vbInformation, "Text changed message..."
            End If
       
        End Sub

---

Pandey,

this was very helpful. you should be MVP of excel. thanks very much. Happy New Year!

Quote:

---

Originally Posted by LalitPandey87

Step1:- Right click on sheet1 tab and click on View code
Step2:- Paste below code

Code:

---


        Private Sub Worksheet_Change(ByVal Target As Range)
       
            If Target.Address(0, 0) = "A2" Then
                MsgBox "Text changed.", vbInformation, "Text changed message..."
            End If
       
        End Sub

---

---