Run a stopwatch for time then execute code
 

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

--
JFamil
-----------------------------------------------------------------------
JFamilo's Profile: http://www.excelforum.com/member.php...fo&userid=1727
View this thread: http://www.excelforum.com/showthread.php?threadid=39271

Run a stopwatch for time then execute code
 

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)


"JFamilo" wrote in
message ...

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

Run a stopwatch for time then execute code
 

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