LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel screen capture to capture cells and row and column headings jayray Excel Discussion (Misc queries) 5 November 2nd 07 11:01 PM
EXcel Capture Data into one cell Luis Excel Worksheet Functions 0 April 19th 06 05:25 PM
capture last cell in column bcamp1973 Excel Discussion (Misc queries) 9 March 10th 06 11:36 PM
How do I capture a text cell as a value to be able to sum? wallace37 Excel Worksheet Functions 2 October 14th 05 08:23 PM
How to automatically capture a tab name in a cell? billj Excel Worksheet Functions 1 July 19th 05 05:14 PM


All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"