Cell Changes in Excel - How Do I Capture Them ?
 

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.

Cell Changes in Excel - How Do I Capture Them ?
 

as answered to your first posting of this question:

There is no way to get or event that reveals the cell or action that
triggered the calculate (the user could have done it by hitting F9 for
example).

added comment:
You might use a combination of Selectionchange and Change to make an
educated guess.

--
Regards,
Tom Ogilvy


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