How Do You Detect A Cell Change In Excel ?

  • Thread starter Thread starter Gordon
  • Start date Start date
G

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.
 
* "Gordon said:
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
?
Click to expand...

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

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