471,082 Members | 802 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

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 2642
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.