Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last changed by Row
Hi. I have a data sheet that I would like to add, in ColumnA, the date that
any contents in that given row have been changed. Every row is a unique set of data. So any changes made to any data in row 5 will have a the date inserted in A5. Possible? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last changed by Row
The techniques here can be adapted:
http://www.mcgimpsey.com/excel/timestamp.html In article , "Steph" wrote: Hi. I have a data sheet that I would like to add, in ColumnA, the date that any contents in that given row have been changed. Every row is a unique set of data. So any changes made to any data in row 5 will have a the date inserted in A5. Possible? Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last changed by Row
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False Me.Cells(Target.Row, "A").Value = Format(Date, "dd mmm yyyy") ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "Steph" wrote in message ... Hi. I have a data sheet that I would like to add, in ColumnA, the date that any contents in that given row have been changed. Every row is a unique set of data. So any changes made to any data in row 5 will have a the date inserted in A5. Possible? Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last changed by Row
Hi,
Think this will work for you. Private Sub Worksheet_SelectionChange(ByVal Target As Range) ThisRow = ActiveCell.Row Range("A" & ThisRow).Formula = "=Today()" End Sub Thanks, "Steph" wrote: Hi. I have a data sheet that I would like to add, in ColumnA, the date that any contents in that given row have been changed. Every row is a unique set of data. So any changes made to any data in row 5 will have a the date inserted in A5. Possible? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a cell be changed on a certain date | Excel Discussion (Misc queries) | |||
Date suddenly changed | New Users to Excel | |||
if a1 value changed then date in b1 | Excel Worksheet Functions | |||
How do I get a date changed automatically | Excel Worksheet Functions | |||
Code - if T changed, change date in W to date it is changed | Excel Programming |