How do I slow down my loop ?

Here's my macro:

Do
Calculate
Loop


That's it. It's a continuous "re-calculate" loop for a countdown clock. Anyone know how I can slow it down (ie: recalculate every 2 seconds) ?

Thanks.

Originally Posted by svanni

Here's my macro:

Do
Calculate
Loop


That's it. It's a continuous "re-calculate" loop for a countdown clock. Anyone know how I can slow it down (ie: recalculate every 2 seconds) ?

Thanks.

an example from chip pearson that can be easily modified to your needs, the original recalcs every 1 sec:
http://www.cpearson.com/excel/BlinkingText.htm

Please Login or Register  to view this content.