ExcelBanter - how can I set up a lag in a macro (like a two minute lag)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I set up a lag in a macro (like a two minute lag)? (https://www.excelbanter.com/excel-discussion-misc-queries/158300-how-can-i-set-up-lag-macro-like-two-minute-lag.html)

Skillionaire

how can I set up a lag in a macro (like a two minute lag)?

I need to download info off of Bloomberg and I need a lag to allow the fields
to populate before I paste the values. Any info anyone has on this would be
much appreciated.

Jim Thomlinson

how can I set up a lag in a macro (like a two minute lag)?

Take a look at the OnTime function. It initiates a macro after a set period
of time. It will be something like this...

Application.OnTime Now() + TimeSerial(0, 2, 0), "MyProcedureName"
--
HTH...

Jim Thomlinson

"Skillionaire" wrote:

I need to download info off of Bloomberg and I need a lag to allow the fields
to populate before I paste the values. Any info anyone has on this would be
much appreciated.

All times are GMT +1. The time now is 04:14 PM.