Ontime event

C

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?
 
B

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)
 
T

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
 
Top