Ok,

I know this has been covered A LOT on here, but I can't find an example
or post that addresses my problem.

I am trying to set up a countdown timer in Excel. I have the equations
and everthing set up, but I have to keep pressing F9 to update. What
would be the VBA code to update the worksheet? I do not necessarilly
want a code that will run a timer, but since I have the =NOW()
function in the sheet as well as a few other calculations, I just want
one macro to update the sheet and loop it so it continues to update
until I run another macro that will stop it. Any help?


---
Message posted from http://www.ExcelForum.com/

Send me your email and address and I will send you a sample workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cmcfalls " wrote in message
...
Ok,

I know this has been covered A LOT on here, but I can't find an example
or post that addresses my problem.

I am trying to set up a countdown timer in Excel. I have the equations
and everthing set up, but I have to keep pressing F9 to update. What
would be the VBA code to update the worksheet? I do not necessarilly
want a code that will run a timer, but since I have the =NOW()
function in the sheet as well as a few other calculations, I just want
one macro to update the sheet and loop it so it continues to update
until I run another macro that will stop it. Any help?


---
Message posted from http://www.ExcelForum.com/

Hi
also see:
http://www.mvps.org/dmcritchie/excel/datetime.htm
(at the bottom of this page)

--
Regards
Frank Kabel
Frankfurt, Germany

"cmcfalls " schrieb im
Newsbeitrag ...
Ok,

I know this has been covered A LOT on here, but I can't find an
example
or post that addresses my problem.

I am trying to set up a countdown timer in Excel. I have the
equations
and everthing set up, but I have to keep pressing F9 to update. What
would be the VBA code to update the worksheet? I do not necessarilly
want a code that will run a timer, but since I have the =NOW()
function in the sheet as well as a few other calculations, I just
want
one macro to update the sheet and loop it so it continues to update
until I run another macro that will stop it. Any help?


---
Message posted from http://www.ExcelForum.com/

I have an example on my website: Schedule a macro to run


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"cmcfalls " wrote in message
...
Ok,

I know this has been covered A LOT on here, but I can't find an example
or post that addresses my problem.

I am trying to set up a countdown timer in Excel. I have the equations
and everthing set up, but I have to keep pressing F9 to update. What
would be the VBA code to update the worksheet? I do not necessarilly
want a code that will run a timer, but since I have the =NOW()
function in the sheet as well as a few other calculations, I just want
one macro to update the sheet and loop it so it continues to update
until I run another macro that will stop it. Any help?


---
Message posted from http://www.ExcelForum.com/

I am not sure I understand what you are trying to do, but check the
Excel/Add-Ins/Countdown Timer page of my web site.

--
Regards,

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

In article , cmcfalls
says...
Ok,

I know this has been covered A LOT on here, but I can't find an example
or post that addresses my problem.

I am trying to set up a countdown timer in Excel. I have the equations
and everthing set up, but I have to keep pressing F9 to update. What
would be the VBA code to update the worksheet? I do not necessarilly
want a code that will run a timer, but since I have the =NOW()
function in the sheet as well as a few other calculations, I just want
one macro to update the sheet and loop it so it continues to update
until I run another macro that will stop it. Any help?


---
Message posted from http://www.ExcelForum.com/