Is there an Excel Mac 2011 equivalent for Sleep

[djamieson18]

Hi All,

I am using Excel Mac 2011 and require the code to wait for a certain period of time. Is there an alternative to using the 'sleep' command as results in an error?

Thanks,

Dave

 

[hrlngrv]

Does Mac Excel provide the Application.Wait method? If so, the following won't let anything run for 10 seconds.

Application.Wait Now + TimeSerial(0, 0, 10)

If you want to allow other things to go on while the macro is waiting, and if Mac Excel provides DoEvents, try

Dim dt As Date
':
dt = Now + TimeSerial(0, 0, 10)
Do
DoEvents
Loop Until Now > dt