| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Real-time clock in excel
Hi all,
I have used the following VBA code to have the real time clock in one of my cells. but it is not working. can any one help me. Sub clock() If ThisWorkbook.Worksheets(1).Range("B1").Value = "X" Then Exit Sub ThisWorkbook.Worksheets(1).Range("A1").Value = Format(Now, "hh:mm:ss AM/PM") Application.OnTime Now + TimeSerial(0, 0, 1), "clock" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i insert a real time clock in excel ? | Excel Discussion (Misc queries) | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| Convert real time to a % in Excel | Excel Discussion (Misc queries) | |||
| can excel be a time clock or stop watch? | New Users to Excel | |||
| Calculating Clock start time in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
