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.

On Wed, 19 Jun 2013 01:59:30 +0100, Paga Mike
wrote:


'RB[_2_ Wrote:
;1612365']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.


I have a workbook in which I have a column of "Y" "N" selection
dropdowns. When that "Y" is selected, that row lights up and its data
appears and its color changes. The color of the Yes/No selection also
changes. I might have it posted ... lemmie check...

http://www.mediafire.com/?a1hwbmmihjmaiyi

Select the number of bands on the left. change it from 6 to 5 and
watch the 6th band disappear, along with its associated data and
descriptor cells.

And of course, the resistor bands change color based on the number you
place in each of those locations.

I should do an entire re-do of it, except that there is not much
through-hole technology left out there. It was a nice exercise though.