Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I Automatically Detect Cell Changes In Excel
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automatically make excel detect directory path for linked f | Excel Discussion (Misc queries) | |||
How can I detect that an excel cell has been clicked | Excel Discussion (Misc queries) | |||
VB ; How do I detect a Comment in a cell | Excel Discussion (Misc queries) | |||
How do I make a formula automatically detect changes in values | Excel Worksheet Functions | |||
Detect when Active Cell Changes | Excel Programming |