How Do You Detect A Cell Change In Excel ?

[Gordon]

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.

[Herfried K. Wagner [MVP]]

* "Gordon" <gh*********@btconnect.nospam> scripsit:

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
?

I would ask this question in one of the Excel groups:

<news://news.microsoft.com/microsoft.public.excel.programming>

General Information:

Event handling Excel + VB.NET:

<http://support.microsoft.com/default.aspx?scid=kb;en-us;302814>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>