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

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hi All - How do i get my vba macro to refresh every minute?	Sam	Microsoft Excel Misc	2	28th Jul 2009 12:22 PM
Hi All - How do i get my vba macro to refresh every minute?	Sam	Microsoft Excel Programming	1	28th Jul 2009 09:32 AM
How to make a macro run every fifth minute	Andreas Ingo	Microsoft Excel Programming	1	18th Jun 2008 04:04 PM
How can I automatically run a macro every 1 minute or every 5 minuts	Lawrence M. Seldin, CMC, CPC	Microsoft Excel Worksheet Functions	2	25th May 2004 10:49 PM
a macro to collect data on a loop every minute.	dynamicsoul	Microsoft Excel Misc	1	22nd Sep 2003 06:10 PM