+ Reply to Thread
Results 1 to 2 of 2

interop detecting linked cell changes

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    us
    MS-Off Ver
    2010
    Posts
    1

    interop detecting linked cell changes

    I have an application that periodically updates cells in excel. These cells are linked to the 'rt' app with formulas like
    =rt|ESZ4!LAST

    I am trying to detect when these cell values change with a .net C# application. I have setup excel interop, and can detect manual cell changes with the worksheet Change event. However, the Change event does not fire when the 'rt' app updates the cell values.
    How can interop detect a value change in one of these linked cells?

    thanks.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: interop detecting linked cell changes

    The only direct event would be the Worksheet_Calculate but that can't be restricted to only react to specific cells recalculating.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Detecting if a cell value is an integer (or not)
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2011, 06:14 AM
  2. Detecting Numbers in a cell
    By KH_GS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2006, 09:07 PM
  3. Detecting a control in a cell?
    By cmpcwil2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2006, 11:25 AM
  4. [SOLVED] detecting keypress(es) in a cell
    By Hernan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2005, 01:00 PM
  5. [SOLVED] automatically detecting changes in a cell
    By Antonio Duarte in forum Excel General
    Replies: 5
    Last Post: 06-15-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1