Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic refresh (F9) in excel ????
I'm sure it has been asked before and seems a pretty simple question, but
can excel automatically refresh (calculate now, F9) ??. i.e. if i wanted to make a simple clock in excel by entering " =now() " into a cell, could i then make excel auto calculate this every second so that it keeps up with current time ?? Cheers Andy |
#2
|
|||
|
|||
Unless you use Tools|Options|Calculate to change things, Excel recalculates
whenever a new formula is entered. With =NOW() in A1, type 5 in C1 and 7 in D1 and =C1+D1 in E1. Now wait a few minutes (make coffee) and change D1 to 20. When you hit the Enter key, nor only is E1 recalculated but so is E1 Alternatively use Format:Cell:Custom to format A1 as hh:mm:ss. Now you need wait only seconds Somewhere, someone has an Excel clock. Try http://www.j-walk.com/ss/excel/files/general.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy100" wrote in message ... I'm sure it has been asked before and seems a pretty simple question, but can excel automatically refresh (calculate now, F9) ??. i.e. if i wanted to make a simple clock in excel by entering " =now() " into a cell, could i then make excel auto calculate this every second so that it keeps up with current time ?? Cheers Andy |
#3
|
|||
|
|||
Careful, this could tie up your system if you do it to long!!! open a new work book, right click and view code paste this in the window Sub Clock() 'Create an iteration counter For i = 1 To Range("b1") 'Recalculate the worksheet Worksheets("sheet1").Calculate 'Update the worksheet with the latest iteration number Range("b2") = i 'Increment value of i by i Next i End Sub In cell a1 =now() format to desired time view in cell b1 enter a number, 5000 would be a good start. then go to tools-macro-select clock-run. -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=472786 |
#4
|
|||
|
|||
Cheers Bernard, i'll give that a try !
Kind Regards Andrew "Bernard Liengme" wrote in message ... Unless you use Tools|Options|Calculate to change things, Excel recalculates whenever a new formula is entered. With =NOW() in A1, type 5 in C1 and 7 in D1 and =C1+D1 in E1. Now wait a few minutes (make coffee) and change D1 to 20. When you hit the Enter key, nor only is E1 recalculated but so is E1 Alternatively use Format:Cell:Custom to format A1 as hh:mm:ss. Now you need wait only seconds Somewhere, someone has an Excel clock. Try http://www.j-walk.com/ss/excel/files/general.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy100" wrote in message ... I'm sure it has been asked before and seems a pretty simple question, but can excel automatically refresh (calculate now, F9) ??. i.e. if i wanted to make a simple clock in excel by entering " =now() " into a cell, could i then make excel auto calculate this every second so that it keeps up with current time ?? Cheers Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
Automatic data conversion in Excel | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL? | Excel Worksheet Functions |