How to create a delay in VBA macro

Does anyone know how to make the macro wait a bit before going on to the next procedure ?
I'm using another application (bloomberg excel) at the same time and it takes a little bit time to be fully updated along with vba, so it is necessary to create a pause between procedures, so that bloomberg can catch up with the progress.

I tried applicationwait function but it didn't work, since it simply stopped the whole process. I'm just wondering if I can create something simple just like countdown or so in the statement.

Regards

Hi,

Try this:

Please Login or Register  to view this content.

I have some dim dark recollection that time delays are troublesome. Can't remember why though.

cheers

Malcolm

Hello TKO321,

In addition to macaulay's code, here is a version that yields to other processes while the macro is waiting. This timer also supports fractional portions of a second.

Please Login or Register  to view this content.

Calliing Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Great. Thanks a lot !