View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Husker87 Husker87 is offline
external usenet poster
 
Posts: 35
Default 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!