Hi:
in excel how do I use the onworksheet change event? to determine then the
cellthe user is in has changed.
Do I have to implement all function for an event sink or canIjust implement
the functions I require, in this case I am using the AppEvents interface.
Any guidance apreciated.
Sean.

Put worksheet change event code on the worksheet code sheet you are
monitoring,
the following tracks cell A1 for changes....

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "A1 has changed"
End If
End Sub

--

Regards,
Nigel




"Sean Farrow" wrote in message
...
Hi:
in excel how do I use the onworksheet change event? to determine then the
cellthe user is in has changed.
Do I have to implement all function for an event sink or canIjust
implement the functions I require, in this case I am using the AppEvents
interface.
Any guidance apreciated.
Sean.