Ontime event

[cmcfalls]

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?

 

[Bob Phillips]

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)

 

[Frank Kabel]

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

 

[Rob van Gelder]

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

 

[Tushar Mehta]

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