I have an MS EXCEL workbook sheet named 'Simulator' (which is always open) and it will receive DDE values from another application running on the same PC
I want to check every second if certain cells containing DDE values in my worksheet 'Simulator' change their value.
e.g. If the value in Cell A1 changes at any time then I want to compare the value in A1 to a known value to determine what to do ....
If A1 = 0 then do nothing
If A1 = 1 then increment B1 by 1 every second until B1 = C1
If A1 = -1 then decrement B1 by 1 every second until B1 = D1
I want to further extend this such that every second I check a range of cells from A1 to A100 and if any of them change then I want to put a value in the relative B cell in the same row
If A43 = 0 then do nothing
If A43 = 1 then increment B43 by 1 every second until B43 = C43
If A43 = -1 then decrement B43 by 1 every second until B43 = D43