3

Is it possible, and if so how, to listen to changes in an Excel range from within C# using the MS interop libraries?

I know how to read the value in a named range, but don't know how to listen and automatically pick up changes. Been through Google and not found anything to solve this...

clicky
  • 865
  • 2
  • 14
  • 31
  • What have you tried so far to solve this? Show your effort first.. You can read [FAQ] and [ask] – Soner Gönül Apr 06 '13 at 15:43
  • 1
    *le sigh* I've trawled through the GOOG and played with the API but havn't managed to do it. Maybe I'm missing somehting simple though. Is that OK? – clicky Apr 06 '13 at 15:45
  • 1
    Depends on what you exactly want to do... Not sure if you have seen this link? http://support.microsoft.com/kb/823981 – Siddharth Rout Apr 06 '13 at 16:53
  • Thanks I'll use this and Mitja's advice - should get the job done – clicky Apr 06 '13 at 19:14

1 Answers1

2

I don't think Range object has a Change event. You can listen to the Worksheet Change event and probably do a bit more checking to figure out if the change is the one you want to catch.

Mitja Bezenšek
  • 2,503
  • 1
  • 14
  • 17