Thread
:
Updating Time when a field has been modified
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
Updating Time when a field has been modified
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = 2 Then
.Offset(, -1).Value = Now
End If
End With
End Sub
HTH
--
AP
"Joshua Vista Star" <Joshua Vista
a écrit
dans le message de
...
-- This one is a toughy!!!!!!!
Goal:
I have two colums and multiple rows. I would like to updated the first row
with
the time that the second row was modified.
Problem:
When ever the second row is modifed every-time stamp in the first colum is
updated.
I need to update the time in each row independently - and keep it from
being
modified or updated.
Reply With Quote