how to set an interval

[EXCEL NEWS]

hi,

i want to put an interval into a loop

how to do it

for example

for each k in ks

msgbox k.name

interval(say,10 senconds)

next


thanks

[Leith Ross]

Hello,

Here's how...

For Each k In ks
MsgBox k.name
'Pause 10 seconds
Application.Wait(Now + TimeValue("0:00:10"))
Next k

Sincerely,
Leith Ross

[avveerkar]

Wait will work but will suspend all other operations. In case you want do " some thing else " while your timer is also running, use OnTime method. It is like setting an alarm. You set OnTime for 10 secs to execute your procedure and do whatever else you want to do. At exactly at the set time your proc will execute. At the end of your proc you could set another OnTime for 10 secs and you are free to do something else instead of waiting for loop to count 10 seconds.

A V Veerkar

[EXCEL NEWS]

Thanks a lot.

Thanks to　all.

"Leith Ross" <[email protected]> wrote
in message news:[email protected]...
>
> Hello,
>
> Here's how...
>
> For Each k In ks
> MsgBox k.name
> 'Pause 10 seconds
> Application.Wait(Now + TimeValue("0:00:10"))
> Next k
>
> Sincerely,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=508818
>