Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
recording a data entry date
How do I automatically record the original date of a data entry into a
specific cell? I do not want the date to update if the cell entry is modified. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
recording a data entry date
Rusty
Either manually Ctrl+; or with a worksheet_change() event which could check if the cell already had a date in it and if so not change it, so for A1 changing, this code will put the date and time modified the first time only in B1. (There is no protection in this code to stop a user changing it Private Sub Worksheet_Change(ByVal Target As Range) With Application .EnableEvents = False If Not .Intersect(Target, Range("A1")) Is Nothing Then If Target.Offset(0, 1).Value = "" Then Target.Offset(0, 1).Value = Now() End If End If .EnableEvents = True End With End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Rusty 1i" <Rusty wrote in message ... How do I automatically record the original date of a data entry into a specific cell? I do not want the date to update if the cell entry is modified. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to double-click for data to be recognised as date?! | Excel Discussion (Misc queries) | |||
Simplified Data Entry | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
After concatenating data, how do I get Excel to recognise date? | Excel Discussion (Misc queries) | |||
Drop-Down Menus in Data Entry Form? | Excel Discussion (Misc queries) |