Run a stopwatch for time then execute code

[JFamilo]

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

 

[Bob Phillips]

If you don't want to see the time counting down, you could use this solution
I posted a few days ago http://tinyurl.com/94g9s

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tushar Mehta]

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