Check if input cells change

[-Sindre]

Hi,

I use iterative calculations in an excel-workbook I have made. For some of the calculations I need a counter. It should start at 0,95 and decrease by 0.01 for each iterative calculation. This I've managed. But I need it to restart at 0,95 when someone changes an input cell in the workbook (one of 3 possible input cells). My plan was to make another cell contain 1 if something is changed and 0 if something is not changed. Then restart at 0,95 if that cell shows 1.

Then it should work like this: If someone changes the input cell the check cell changes to 1, then the counter changes to 0,95. For the next iteration nothing has changed so the check cell changes to 0 and the counter changes to 0,94 etc.

I thought you could just make another cell equal the input cell and then put the check cell in between because excel starts calculations at A1 and then move to the right and down. This didn't work. Does anyone know how to fix this? Or another solution? Would prefer to solve it without VBA, but if that isn't possible I can do that aswell.

Thank you for any answers!

[TMS]

I think you WILL need VBA. And you would use a Worksheet Change Event handler to monitor the three Input cells. If any of them change, reset the starting value.

[-Sindre]

Okay.

How can I reset the value with VBA? If I set D5554 = 0,95 in the VBA code, will it not overwrite the equation that was there already?

The cell looks like this now:
=IF(ISERROR(D554);D553;IF(OR(D554<0,65;D548=1);D553;IF(D583=1;D554-0,01;D554)))

D548 = Check if input is changed (doesn't work)
D553 = The start value (0,95)
D554 = The counter
D583 = The main check, as long as this is 1 the counter will decrease