How to detect the cell's value change?
 

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

How to detect the cell's value change?
 

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