View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Calculate amount of change in a single cell

Not very practical, but just for fun....
Create 2 Option Buttons from Forms,
label them "Lock" and "Capture"
and link them a cell named "Cont".
Deliberately turn on Iterations, max=1.
In a cell named "Store" enter
=IF(Cont=2,IN,Store)
Click "Capture" and then "Lock".
The number in "IN" will be stored in "Store"
and can be compared to the current "IN".