Detecting excel events

Add-in Express™ Support Service
That's what is more important than anything else

Detecting excel events
 
Jyrki Degerman


Guest


How to dectect that value of excel cell is changed?
Posted 03 Jul, 2004 15:01:13 Top
Guest


Guest


Jyrki,

I have just found this within VBA help:


Change Event

Occurs when cells on the worksheet are changed by the user or by an external link.

Syntax 

Private Sub Worksheet_Change(ByVal Target As Range)


Target The changed range. Can be more than one cell.

Remarks

This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation.

Deleting cells doesn't trigger this event.
Posted 04 Jul, 2004 06:37:52 Top