Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update date field upon cell range change
Excel 2003
I have a shared spreadsheet and the users can change any cell between A4:K100. The date is in A3. I'm looking for code which would put today's date in A3 when any cell in A4:K100 is changed. If someone opens the report, but does not change it, the date does not change. That way, when the users prepare for a meeting, they know if they have the latest report. I checked out Timestamp, but didn't find what would suit this need. TIA, Carole O |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update date field upon cell range change
Carole
Don't know why JE's Timestamp won't work but try this. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A4:K100")) Is Nothing Then With Target If .Value < "" Then Range("A3").Value = Format(Now, "dd mmm yyyy hh:mm:ss") End If End With End If ws_exit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Tue, 15 May 2007 20:18:00 -0700, Carole O wrote: Excel 2003 I have a shared spreadsheet and the users can change any cell between A4:K100. The date is in A3. I'm looking for code which would put today's date in A3 when any cell in A4:K100 is changed. If someone opens the report, but does not change it, the date does not change. That way, when the users prepare for a meeting, they know if they have the latest report. I checked out Timestamp, but didn't find what would suit this need. TIA, Carole O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update a date cell when a target cell change.... | Excel Discussion (Misc queries) | |||
update cell only if now() falls in a given date range | Excel Worksheet Functions | |||
Update cell based on date range | Excel Discussion (Misc queries) | |||
Field , Date range and Sum from worksheet import | New Users to Excel | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions |