View Single Post
  #2   Report Post  
Paga Mike Paga Mike is offline
Junior Member
 
Location: Lakehurst, NJ, USA
Posts: 19
Default

Quote:
Originally Posted by RB[_2_] View Post
I have a model that uses three variables to give the final result. Each of these variables can be changed and the final result will also change. I want to record the value of the final result each time I make a change to the variable. How can I record that changing value?
You could use an Event Macro.

The macro could be triggered each time one of the input cells is updated. The macro would then record the result in a separate worksheet.