View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] ryanmhuc@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 1
Default Worksheet_Change does it fire for a cell changed via foruma?

I know the Worksheet_Change fires for when a user updates a range of
cells and the range of cells is passed to the Worksheet_Change sub.
What about when a cell is changed from a formula? Worksheet_Change
doesn't seem to fire when a cell is changed as a result of a forumula
calucation.

Example:
Cell A2 is calcuated by the value of A1 + 1

If you change A1, A2 now changes as well but the Worksheet_Change is
fired but the Target only includes A1 and Worksheet_Change is not
fired again for A2.

Is there a way to capture the change just on A2?

Obviously on every change i can just check to see if i need to make my
adjustments. But their is a performance reason why i cannot. So i only
want to run if indeed the correct cell has been changed not on every
change.