Link to home
Start Free TrialLog in
Avatar of finnstone
finnstone

asked on

how can i add a timer to this hyperlink opening code

the attachde vba opens urls all at once . i want to specify a time delay....one that i can set when i run the macro...think i need a form control. any ideas?

thanks!
ALL-MACROS.xlsm
Avatar of Rgonzo1971
Rgonzo1971
Hi,

pls try 
Application.Wait(Now + TimeValue("0:00:02"))

Open in new window

Regards
Avatar of finnstone
finnstone

ASKER

I ACTUALLY NEED A TIMER THAT ITSELF IS VARYING

SO EVERY TEN LOOPS, IT CHANGES THE DELAY BY 1 SECOND. so delay for n=1-10 is 10 seconds and delay for n=11-20 is 11 seconds

attached is the code working so that every loop it changes by a fixed amount....got it that far, now just need it to be more dynamic
ALL-MACROS.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of finnstone
finnstone

ASKER

can you do another one? i will post it soon, similar algo logic
Avatar of finnstone
finnstone

ASKER

thx!
Avatar of finnstone
finnstone

ASKER

this overflows at 32000 (iteration 14)

lngDelay = (10 + (intLoopcnt \ 2)) * 2000