Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change events and linked cells
I never use linked cells. But some of the users of my programs use this
feature extensively. Now that we have upgraded to Excel 2002 I have been making extensive use of the cell change event. A user has complained about some problem with change events not being picked up with linked cells. But he wasn't able to demonstate if for me. Generally he has multiple spreadsheets open. What nuances do I need to be aware of with the change event and linked cells? Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change events and linked cells
Don
"Don Wiss" wrote in message ... I never use linked cells. But some of the users of my programs use this feature extensively. Now that we have upgraded to Excel 2002 I have been making extensive use of the cell change event. A user has complained about some problem with change events not being picked up with linked cells. But he wasn't able to demonstate if for me. Generally he has multiple spreadsheets open. What nuances do I need to be aware of with the change event and linked cells? None, I think. A linked cell will undoubtedly have a formula in it (if I understand you). The Change event will only fire when the user (or a macro) enters something into a cell, not when the value changes as the result of a recalculation. What problems did the user have? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine 2 worksheet change events | Excel Discussion (Misc queries) | |||
VBA Code; need linked cells to change color if condition met | Excel Worksheet Functions | |||
Cell change events | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
linked cells change to literals | Excel Discussion (Misc queries) |