Detecting the change of a certain cell
 

Dear All:

Is it possible that someone can kindly tell me how to detect the change of a
certain cell?

environment is VSTO + VS 2008 + EXCEL 2007.

the Globals.sheet1.Calculate += is successful

but the Globals.sheet1.Change doesn't work.

Could anyone provide a sample?

FYI the code is written within a window Form.


Best Regards,


Fan