Run code after entry

[Guest]

What type of code should I use if I want to keep an eye on any entry changes
made in Sheet1.Range("A1") without activating code manually?

I think im looking for something like:

Sub Sheet1.Range("A1")_Change
'my code checking the contents of Sheet1.Range("A1")
End Sub sub

Thanks
The Doctor

 

[WillR]

try this


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
MsgBox "Put your code here!"
End If
End Sub

 

[Rog]

There is an in-built event to trap this in each worksheet
object :

Look for :

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

End Sub

in Sheet1 object

Rgds

Rog