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

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


--
WillR
------------------------------------------------------------------------
WillR's Profile: http://www.excelforum.com/member.php...nfo&userid=145
View this thread: http://www.excelforum.com/showthread...hreadid=263126

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



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