How do I trigger a macro a cell in updated
Posted by Maged Ghatas on August 10, 1999 5:01 AM
I need to be able to start a macro when certain cells are updated. The Worksheet_Change will only work if the user applies the changes, which means if I want to base may trigger on a cell with a formula (for example, the sum of other cells), changing the values of the other linked cells will not have an effect on this event handler.
If there is no solution then is there a macro that could be triggered by scheduled times set on a programming level, i.e. At 3:02, If Not_Ready then Reschedule(3:05) Else Update_Data.