| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updated times stamp of last change
I have a shared excel file. How do I display a time stamp of what time the
latest change was made? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Updated times stamp of last change
Several ways to do this.
Event code can be tailored to suit your needs. Where would you like to see the timestamp? On one sheet or on all sheets? This sheet event code would give you a timestamp in B1 whenever A1 was changed. I'm sure you have something more complex in mind, but example only.. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Target.Offset(0, 1).Value = Now() End If End Sub Gord Dibben MS Excel MVP On Fri, 30 May 2008 12:15:01 -0700, rciolkosz wrote: I have a shared excel file. How do I display a time stamp of what time the latest change was made? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Excel files change size when updated | Excel Discussion (Misc queries) | |||
| I need a date stamp that doesn't change when you enter text | Excel Worksheet Functions | |||
| How to have:= NOW () date/time change only if updated and saved | Excel Worksheet Functions | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
| Time Stamp-With Change | Excel Discussion (Misc queries) | |||
Linear Mode
