Capturing changing data

Hi,

I am new to macros/ vba coding so bear with me if I dont understand certain terms.

I am running a simulation in excel, assigning 1 = if an event happen, and 0 = if an event does not happen. Data is live and keeps changing. I would like to capture the data field and time stamp whenever "1" happens.

I have found the below vba code in another forum and it works if i hard code the number in A1 (let A1 = 1 or 0). However, if I make A1 = sum (B1:C1), data does not display on sheet "Tracker".

Is it possible to capture data from A1:C1 whenever A1 meets the trigger criteria?

Please Login or Register  to view this content.

the ws_calculate event will trigger every time anything on the sheet "recalculates". I don't know if this works for you or not as all it does is check the value of A1 and if it is 1, records the timestamp. Seems too simple, but it's a starting point.

Please Login or Register  to view this content.