detect the change of a certain sheet.cells

[Fan Zhang]

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

 

[DeveloperX]

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

Works for me. Are you doing RTD stuff, or simply trying to trigger
something on a cell change. RTD events do not fire the Change event.