determine when the user moves to a difference cell

S

Sean Farrow

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

Nigel

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
 
Top