determine when the user moves to a difference cell
 

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.

determine when the user moves to a difference cell
 

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.