Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
you might try to use Worksheet_Change event (go to sheet tab, right-
click on it, click Show code, instead of "(General)" select "Worksheet" and then "Change" in the rightmost window) Private Sub Worksheet_Change(ByVal Target As Range) Cells(Selection.Row - 1, 1) = Time End Sub provided entering data moves you 1 row down however this will cause time to be entered to cells in 1st column also on editing any cell HIH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
Automatic date and time updation | Excel Discussion (Misc queries) | |||
excel, automatic date and time when info gets entered | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |