In VBA, how can I pause / wait execution in code for n number of seconds? Is there a function?
K KitCaz May 20, 2005 #1 In VBA, how can I pause / wait execution in code for n number of seconds? Is there a function?
A Allen Browne May 20, 2005 #2 Simple wait for 5 seconds: Dim dt As Date dt = DateAdd("s", 5, Now() Do While Now() < dt DoEvents Next If you want something more complex: http://www.mvps.org/access/api/api0021.htm
Simple wait for 5 seconds: Dim dt As Date dt = DateAdd("s", 5, Now() Do While Now() < dt DoEvents Next If you want something more complex: http://www.mvps.org/access/api/api0021.htm
