468,525 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,525 developers. It's quick & easy.

detect the change of a certain sheet.cells

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
Jul 25 '08 #1
1 2546
On Jul 25, 8:04*am, "Fan Zhang" <min...@gmail.comwrote:
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.
Jul 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Roy | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.