Worksheet Change Event

[jamilm]

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.

[LalitPandey87]

Step1:- Right click on sheet1 tab and click on View code
Step2:- Paste below 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

[jamilm]

Pandey,

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


Step1:- Right click on sheet1 tab and click on View code
Step2:- Paste below 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