Home |
Search |
Today's Posts |
#3
|
|||
|
|||
Hi CC
You can do it with the change event of the worksheet This example will place the date/time in the B column if you change a cell in the range A1:A20. Place the code in the Sheet module Right click on a sheet tab and choose view code Paste the code there Alt-Q to go back to Excel Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("a1:a20"), Target) Is Nothing Then Target.Offset(0, 1).Value = Format(Now, "mm-dd-yy hh:mm:ss") End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "CC" wrote in message ... I keep a list of students and activities. Because the number of students per activity is limited, I would to track the date and time when they selected their activity: Student Activity Date --------- -------- ----------- Smith Tennis 02/01/05 I would like the cells in the Date column to change automatically when the Activity value is changed. Thanks a lot, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |