You may want to look at a shareware solution:
VBA Timer object for developers (beta version)
http://www.tushar-mehta.com/excel/software/vba_timer/

See the Examples section to get an idea of what can be done with the
add-in.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I would like to write a sub that runs a stopwatch continuously... then
when it reaches a certain time, say 15 mins, then it will run code that
saves the file you are currently working on to a specific location.
Kind of like the AutoSave feature. The problem being is that while the
timer is running I want the user to be able to run other code (not
always predetermined since we are working with userforms) Is there a
way to do something like this? Thanks!


--
JFamilo
------------------------------------------------------------------------
JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276
View this thread: http://www.excelforum.com/showthread...hreadid=392714