Counting time in IF formula

[Jan Kalop]

How to set in formula waiting time before the command is run.
For sample
=hold on for 10 sec before IF(SUM(A1:A20)<0,"",SUM(A1:A20))

 

[Misca]

You can't put formulas to hold on for anything. If you change the calculation mode to Manual the formulas calculate when you press F9 or save the workbook. But even that's not timed.

With VBA you can force things to happen at certain time. This line of code waits for 10 sec before executing the next line:

[COLOR=#242729][FONT=Consolas]Application.Wait (Now + TimeValue("0:00:10"))[/FONT][/COLOR]

 

[Jan Kalop]

You can't put formulas to hold on for anything. If you change the calculation mode to Manual the formulas calculate when you press F9 or save the workbook. But even that's not timed.

With VBA you can force things to happen at certain time. This line of code waits for 10 sec before executing the next line:

[COLOR=#242729][FONT=Consolas]Application.Wait (Now + TimeValue("0:00:10"))[/FONT][/COLOR]

Thanks, but it is not what I was expecting, because it is a bit more complicated. I run VBA "Target As Range" and I am afraid that only slow my process. I would like only the "time count" jump in, in between every VBA "Target As Range" run, which is running in a loop from appointed start date to the present. Maybe would be possible to add that function on the very end of the VBA "Target As Range" script ?, or even would be better to stop the loop and activate it with appointed key ??