Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Stamp
How can I modify this code so that every time a Worksheet_Change event
occurs it will but the current date and time in cell (L1) over writing the last update? In addition win the files is open it show show the time of the last update. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 11 Then If IsEmpty(Target) Then Target.Offset(0, 1).Value = Empty Else Target.Offset(0, 1).Value = Now() End If End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Stamp
Little Penny, whenever a change occurs anywhere in the sheet, is that what
you want? Private Sub Worksheet_Change(ByVal Target As Range) Range("L1") = Now End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Little Penny" wrote in message ... How can I modify this code so that every time a Worksheet_Change event occurs it will but the current date and time in cell (L1) over writing the last update? In addition win the files is open it show show the time of the last update. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 11 Then If IsEmpty(Target) Then Target.Offset(0, 1).Value = Empty Else Target.Offset(0, 1).Value = Now() End If End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Stamp | Excel Worksheet Functions | |||
Time Stamp | Excel Programming | |||
Time Stamp | Excel Programming | |||
time stamp a cell that doesn,t change when time stamping another | Excel Programming | |||
Time Stamp | Excel Discussion (Misc queries) |