MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
When you insert "=now()" into a cell which is set to a time mode (14:05:07), how can I see the seconds counting?
print out 60 copies and make a flick book?
Press F2 and enter once a second
Is ST Failing me???????
you need a VBA loop.
Dont think you can do it without a custom function though Stoner will be along in a minute to prove me wrong 🙁
print out 60 copies and make a flick book?
Nice.
why not get a watch?
I spend too much on bikes! 😉
Sub count_time()
Range("A1").value = now()
While 1 = 1
Range("A1").Calculate
Wend
End Sub
Will have to use Ctl+C to kill it though 🙂
STW has its limits (though I haven't reached them yet) so you might want to try here.
[url= http://www.mrexcel.com ]Mr Excel[/url]
SR - Whats that formula in thicko terms?
the first google search of excel clock reveals the vba you need to do this.
ok 😥
Whos_Daddy
Its VBA you have to go hit alt+F11 to go to the VBA editor.
Paste in the code.
go back to your worksheet.
add the forms toolbar.
draw a button on the sheet.
assign your macro to the button
click button and it will refresh the cell in a never ending loop.
Not pretty but thats what he asked for 😉
Ctl+C to kill the loop.
🙂
You could easily put a time constraint in :
Sub count_time()
Dim bob as date
bob = now()+ 0.001
Range("A1").value = now()
While now() <> bob
Range("A1").Calculate
Wend
End Sub