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



--
Dr Fan Zhang
UTHSC, RWW Lab

[DeveloperX]

Re: detect the change of a certain sheet.cells

On Jul 25, 8:04 am, "Fan Zhang" <min...@gmail.c omwrote:

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
>
--
Dr Fan Zhang
UTHSC, RWW Lab

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.