Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have a cell display the date its row was last updated?
Hiya,
does anyone know how to have a cell automatically display adate that is refreshed to today whenever its row is updated? - would be massively useful... many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have a cell display the date its row was last updated?
http://www.mcgimpsey.com/excel/timestamp.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "castell" wrote in message ... | Hiya, | does anyone know how to have a cell automatically display adate that is | refreshed to today whenever its row is updated? - would be massively useful... | | many thanks! | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have a cell display the date its row was last updated?
How to insert code into worksheets:
http://www.jlathamsite.com/Teach/WorksheetCode.htm Just change "A" to whatever column the date should be placed into on the current sheet/row where a change was made. If you need this on several sheets, each worksheet needs this code added to it's _Change() event. Private Sub Worksheet_Change(ByVal Target As Range) Const DateCellColumn = "A" ' change If Target.Cells.Count 1 Then Exit Sub End If Application.EnableEvents = False Range(DateCellColumn & Target.Row) = Now() Application.EnableEvents = True End SubHow to insert code into worksheets: http://www.jlathamsite.com/Teach/WorksheetCode.htm Just change "A" to whatever column the date should be placed into on the current sheet/row where a change was made. If you need this on several sheets, each worksheet needs this code added to it's _Change() event. Private Sub Worksheet_Change(ByVal Target As Range) Const DateCellColumn = "A" ' change If Target.Cells.Count 1 Then Exit Sub End If Application.EnableEvents = False Range(DateCellColumn & Target.Row) = Now() Application.EnableEvents = True End Sub "castell" wrote: Hiya, does anyone know how to have a cell automatically display adate that is refreshed to today whenever its row is updated? - would be massively useful... many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
formatting a cell to display the correct date. | Excel Discussion (Misc queries) | |||
display last cell in a column as the sheet is updated | Excel Worksheet Functions | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |