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
(E-Mail Removed)



"Sean Farrow" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>