Worksheet Change Event

[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