Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update upon entry
I have a spreadsheet with numerous cells at the top of the page I have the
current date. Is there a way to have the date automatically change to the current date any time a cell is edited/changed on the worksheet? Any help is greatly appreciated! |
#2
|
|||
|
|||
Robyn
Copy the following event macro into the sheet module for that sheet. To do this, right-click on the sheet tab, select View Code, and paste this macro into that module. As written, this macro will insert the current date and time into cell A1 if any cell on the entire sheet changes content. This includes changing to blank. Format A1 to display whatever you want, date or time or both. HTH Otto Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) = "A1" Then Exit Sub Application.EnableEvents = False Range("A1") = Now Application.EnableEvents = True End Sub "Robyn Bellanger" wrote in message ... I have a spreadsheet with numerous cells at the top of the page I have the current date. Is there a way to have the date automatically change to the current date any time a cell is edited/changed on the worksheet? Any help is greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
possible to have =now() at data entry and not update after that? | Excel Worksheet Functions | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
2003 update link when Source open | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions |