Countdown Timer

Hi all,

I've been working on a problem where some text files are imported every minute into an excel template. I have everything working, and am just putting in the final touches like start/stop buttons and a countdown timer to let users know when the next text import is scheduled to occur.

For lack of any VBA skills, I have included a while loop into my timer, to display time to next import in seconds:

Please Login or Register  to view this content.

This successfully runs my macros every minute and displays a countdown timer, however this while statement is causing the mouse pointer to go into "egg timer" mode, and it is now not possible to push the "Stop" button that I set up to stop all macros.

I understand that pushing CTRL + Pause Break will effectively stop the macros, however I need this to be highly user friendly.

Is there another, better way to run the countdown timer????

Cheers,

Zaphius