How to detect the cell's value change?

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

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
 
Back
Top