Time please

  • Thread starter Thread starter Stig - tame racing driver
  • Start date Start date
S

Stig - tame racing driver

Can you add the current time to a cell which auto updates by the second ??

E.g. =now()

Regards
Derek
 
i'm not sure i would ever do it, with the system timer in the bottom right
corner of most screens and the time only changing every minute, but here you
go. Put in a module and don't plan on running other code.

Sub MyTimer()
Do
Application.Wait Now + TimeValue("00:00:01")
sheet1.cells(1,1)="=now()"
Loop
End Sub
 
Nice one..........

Cheers for that


John Bundy said:
i'm not sure i would ever do it, with the system timer in the bottom right
corner of most screens and the time only changing every minute, but here
you
go. Put in a module and don't plan on running other code.

Sub MyTimer()
Do
Application.Wait Now + TimeValue("00:00:01")
sheet1.cells(1,1)="=now()"
Loop
End Sub
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel help - Is there a way to 3
ested IF wont work as I need 18 1
Keyboard shortcut to select a column? 7
The next Grand Theft Auto title has been officially announced 0
incorrect output of if formula 6
Listing Unique Items 3
time auto entry 11
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8

Back
Top