Record date of cell alteration

felipefio

New Member
Joined
Feb 27, 2010
Messages
26
Hello everybody!

I'd like that when data is stored in a cell, the cell in the next column in the same line give me the date in wich it occurred.

It seems simple at start but I'm not good at all with VBA.

Tks!!!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

mvptomlinson

Well-known Member
Joined
Mar 10, 2008
Messages
2,638
You can use a worksheet_change event to check if a cell has been modified, and if so insert the date into the cell to the right of it. For example, if you entered data into column I, and wanted dates to show up in column J you could use:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("I:I")) Is Nothing Then
    Target.Offset(0, 1).Value = Date
End If
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,099,807
Messages
5,470,894
Members
406,733
Latest member
darzu

This Week's Hot Topics

Top