Automating a macro

[ddsole]

I have a spreadsheet that continuously performs calculations with time. It is updated every second. There are cells with formulas that are continuously incrementing as the seconds count on. When a certain condition is reached, as indicated by a cell with a TRUE/FALSE condition, I want to automatically paste the value of the incrementing cell into another cell. I perform this now with a macro that uses the paste special value option, watch for when the indicator cell goes true, and manually enter the macro execute key. Is this someway to make the macro automatically execute when the indicator cell goes TRUE?

 

[Swamp Thing]

There are many ways, but in your case it is actually a macro that causes the change in the first place (or so I gather from your description)... so you can add a couple of lines to the same macro to check for the result of the previous calculation before triggering the next one.

Perhaps your once-a-second calc. is triggered using OnTime? if so, you can add:

If range("TrueFalse") then CopyResult

at the top of the event handler, and put your copying routine in Sub CopyResult()