Can i update without pressing F9?

[Wicked_Clown]

Ok i don't know if this has been asked before but i will ask it now. i recently made my own countdown on my excel using simple math formulas but i have it go all the way to seconds and if i want the seconds to be running while I'm looking at it i need to hold F9. This makes the whole thing update but i was wondering if there was something i could do to make it update its self. oh and I'm kinda new to Excel so please explain it well. Thanks for reading

 

[Tony Miall]

G'day,

Change the calculation to automatic.

Tools/options/Calculation, check the button next to automatic.

 

[Jinspet]

someting like this ? paste these code into the "ThisWorkbook" ,if you don't know about the macro then these code will be helpless

PrivateSub Workbook_Open()
 Application.OnTime Now +TimeValue("00:00:01"), "GetTime"
End Sub
 
<!--
 
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
 
-->Sub GetTime()
 Application.OnTime Now +TimeValue("00:00:01"), "Refresh"            
End Sub
 
Sub Refresh()
  Range("a1").Value =Format(Now(), "hh:mm:ss")
  Call GetTime
End Sub

 

[Wicked_Clown]

Thanks for the help the macro worked