in vba what command is used to determine if a particular cell on a particular sheet changed? some ki

[Daniel]

in vba what command is used to determine if a particular cell on a
particular sheet changed? some kind of event? how to get the old and new
value of the cell?

 

[David McRitchie]

Hi Daniel,
See http://www.mvps.org/dmcritchie/excel/event.htm

change event
excel does not keep track of the old value, nor can you get
if from the event code.