Hi,
I have managed to get a countdown timer running on my spreadsheet, I also have cells which change in value when the counter is below a certain value (using IF command) I now want to have a macro running off this change in value but I just can't get it to work.
Does anyone know what code I should be using?
Thanks
Countdown timer - call macro?
Hi Linus,
To the best of my knowledge it is not possible to trigger a macro from a change in value on a spreadsheet. If anyone has a way then that's a sort of holy grail.
Depending on exactly what you are trying to do the only way to sort of achieve the same result would be to use an IF statement in your macro to the effect of if cell equals x (you need to specify as a range) then do Y.
You would then need to write, either as a separate macro or within this one, an OnTime or OnChange subroutine so that either every refresh or every so many seconds the macro runs and therefore trigger if requisite condition met.
Regards
To the best of my knowledge it is not possible to trigger a macro from a change in value on a spreadsheet. If anyone has a way then that's a sort of holy grail.
Depending on exactly what you are trying to do the only way to sort of achieve the same result would be to use an IF statement in your macro to the effect of if cell equals x (you need to specify as a range) then do Y.
You would then need to write, either as a separate macro or within this one, an OnTime or OnChange subroutine so that either every refresh or every so many seconds the macro runs and therefore trigger if requisite condition met.
Regards
