Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continuous calculation of a formula. | Excel Discussion (Misc queries) | |||
Continuous calculation of a formula | Excel Worksheet Functions | |||
Continuous Averages Formula | Excel Worksheet Functions | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Making a formula continuous | Excel Discussion (Misc queries) |