Continuous calculation of a formula.
 

I created a €œCountdown€� clock to an event in our company. Just the actual
date minus todays date. Anyway, it just calculates days, hours, mins, secs
until an event. The problem is that you either have to hit F9 or some other
cell to get it to re-calculate the formulas. I set up a macro and tied it to
a €œrefresh€� button but does anyone know how I could get the spreadsheet to
calculate every second automatically or perhaps another way to add a
€œCountdown clock€� to my spreadsheet?
Thanks!

Continuous calculation of a formula.
 

Hi,

Don't you already have an answer on this one? Anyway,

A repeating sub routine
==========================

Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:00:01"), "my_Procedure"
End Sub

Sub my_Procedure()
Application.OnTime Now + TimeValue("00:00:01"), "my_Procedure"
ActiveSheet.Calculate
End Sub

Put these into the thisWorkbook object of the VBA editor. It will start
when you open the workbook.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Husker87" wrote:

I created a €œCountdown€� clock to an event in our company. Just the actual
date minus todays date. Anyway, it just calculates days, hours, mins, secs
until an event. The problem is that you either have to hit F9 or some other
cell to get it to re-calculate the formulas. I set up a macro and tied it to
a €œrefresh€� button but does anyone know how I could get the spreadsheet to
calculate every second automatically or perhaps another way to add a
€œCountdown clock€� to my spreadsheet?
Thanks!