To calculate 2 Live variables constantly changing !

[omega0010]

C1 AND D1 ARE LIVE VALUES WHICH ARE ALWAYS CHANGING. CI WILL ALWAYS BE EITHER THE SAME OR >OLDAVLUE C1. D1 CAN BE MORE OR LESS THAN THE PRVIOUS VALUE. I NEED TO CALCULATE 5 SUCH VALUES
THIS MEANS THA I AM EXPECTING THE VALUES IN E1-E5( C2 TO D5 WILL BE LIVE VALUES. C2 IS NOW JUST TO TEST THE CODE
please give the code for at least 2 lines

e1=IF(C1>OldValueC1,(IF(D1=OldValueD1,IF(OldValueE1<0,OldValueC1-C1,C1-OldValueC1),IF(D1<OldValueD1,OldValueD1-C1,C1-OldValueD1))))

[JBeaucaire]

1) Right-click the Sheet1 tab and select VIEW CODE

2) Paste in this code to automatically operate within this sheet:

Please Login or Register  to view this content.

3) Close the vbeditor and see how it operates.

You should be able to expand on this concept. The trick is we have declared some public variables at the top and store the current values of those cells each time we change the selected cell or change a value that causes a calculation to occur on the sheet.

[omega0010]

Thanks a lot to take the pain to write this code .
Will try to see how it works
Thanks again

[omega0010]

There is a slight change in the last two arguements but despite that the calculation is not coming through
"ElseIf [D1] < vD1 Then
[E1].Value = vC1- [C1]
Else
[E1].Value = [C1] - vC1"

[JBeaucaire]

The macro is updating [E1] based on the logic outlined. You should be seeing something happening in [E1]. I trust you will work with the actual logic to get the math you want with the current vs prior values.