Does VBA code exist that will allow you to invoke a 10 second delay between events ?
R Rob Oct 15, 2007 #1 Does VBA code exist that will allow you to invoke a 10 second delay between events ?
A Allen Browne Oct 15, 2007 #2 Something like this perhaps: Dim dbEnd As Date dtEnd = DateAdd("s", 10, Now()) Do While Now() < dtEnd() DoEvents Loop It might also be possible to use the Timer event of the form.
Something like this perhaps: Dim dbEnd As Date dtEnd = DateAdd("s", 10, Now()) Do While Now() < dtEnd() DoEvents Loop It might also be possible to use the Timer event of the form.
R Rob Oct 15, 2007 #4 Thank you both !!! DaveT said: Dim ST As Date ST = Now While (DateDiff("s", ST, Now())) < 10: Wend Click to expand...
Thank you both !!! DaveT said: Dim ST As Date ST = Now While (DateDiff("s", ST, Now())) < 10: Wend Click to expand...
