View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default retriveing old AND new value of a cell in code

Hi E.J.,

maybe you should add a macro "ChangeMyEnteredValue". You place the
cursor on a cell you want to change and run the macro, which will ADD
the amount that is in the cell to the stock value, then it will enter O
(zero) in that cell. I do not know if this will fire your event but it
does not matter as it will calculate with zero. Now you can enter your
new amount which will correctly fire your event.

arno