View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jonathan jonathan is offline
external usenet poster
 
Posts: 11
Default How to let the looping wait

Hello,all. Can someone help me with this problem:

I am trying to value paste some dynamic data as the NOW Function
changes, but the thing is in the looping I would like to value paste
just every 5 seconds. How to make this realised, that means make the
looping wait, without exausting the computer.

What I have done is let it loop as long as Now is bigger than one num,
then choosing to excute the value paste every 5 seconds. But the
computer goes dead.

thanks a lot.