Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Date Stamp when range changes
Worksheet has changeable data clients input in columns W to AP.
Looking for macro to time date stamp in column V in the same row each time the data is changed anywhere in columns W to AP. Some inputs are freeform text and numbers, some are from dropdown list. Most of the postings show how to have one column update the next column over such as http://www.mcgimpsey.com/excel/ timestamp1.html#alt1 the only way i could get it to work for any changes for all columns was to run the test for each column which starts to take time. Seems like there should be an easier way to post the data to column V for each row that regardless of which column generated the change event. Possilbe to change McGimpsey's code to accomplish this task? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Date Stamp when range changes
One way:
Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Count 1 Then Exit Sub If Not Intersect(Range("W:AP"), .Cells) Is Nothing Then On Error Resume Next Application.EnableEvents = False If IsEmpty(.Value) Then .EntireRow.Cells(22).ClearContents Else With .EntireRow.Cells(22) .NumberFormat = "dd mmm yyyy hh:mm:ss" .Value = Now End With End If Application.EnableEvents = True End If End With End Sub In article .com, "PZ" wrote: Worksheet has changeable data clients input in columns W to AP. Looking for macro to time date stamp in column V in the same row each time the data is changed anywhere in columns W to AP. Some inputs are freeform text and numbers, some are from dropdown list. Most of the postings show how to have one column update the next column over such as http://www.mcgimpsey.com/excel/ timestamp1.html#alt1 the only way i could get it to work for any changes for all columns was to run the test for each column which starts to take time. Seems like there should be an easier way to post the data to column V for each row that regardless of which column generated the change event. Possilbe to change McGimpsey's code to accomplish this task? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date-time stamp | Excel Discussion (Misc queries) | |||
TIME STAMP FOR A RANGE | Excel Discussion (Misc queries) | |||
Date-Time Stamp | Excel Discussion (Misc queries) | |||
date/time stamp | Excel Worksheet Functions | |||
Date time stamp | Excel Programming |