Hello,
In my vbasic application I am using Excel automation.
How to detect (which event to use) when user changes the value of the
selected cell?
Thanks,
Jack

Hi Jack

The Worksheet_Change event is what you need. It returns a Target range,
which is the cell beeing changed.

Private Sub Worksheet_Change(ByVal Target As Range)
msg = MsgBox("Cell " & Target.Address & " has been changed")
End Sub

Regards,
Per

"Jack" <replyto@it> skrev i meddelelsen
news:(E-Mail Removed)...
> Hello,
> In my vbasic application I am using Excel automation.
> How to detect (which event to use) when user changes the value of the
> selected cell?
> Thanks,
> Jack
>