View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gordon[_11_] Gordon[_11_] is offline
external usenet poster
 
Posts: 3
Default How Do I Automatically Detect Cell Changes In Excel

No takers from all you Excel experts out there ?

"Gordon" wrote in message
...
Hi there,

I have a VB.NET application which opens a new Excel workbook (and

obviously
worksheet). The cell values in the worksheet depend on certain formulae,
therefore the sheet Calculate event is triggered whenever a calculation
occurs.

My problem is that I can't find a way within this event to find out

exactly
which cell has changed. This is possible with the sheet Change event,
because it passes back the changed row as a parameter, but unfortunately
this event event doesn't get triggered when a calculation occurs, so I

can't
use it.

Are there maybe any Excel.Range events that I can use to resolve this

issue
?

Help !

Gordon.