Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
First entered I guess means if the data changes leave the first date in.
Here is an example for data entered in column A. Dates are automatically entered in column B: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub End If If IsEmpty(Target.Offset(0, 1)) Then Application.EnableEvents = False Target.Offset(0, 1).Value = Now() Application.EnableEvents = True End If End Sub This is worksheet code and does not go in a standard module. -- Gary''s Student gsnu200712 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Functions | Excel Worksheet Functions | |||
IF and Date Functions | Excel Worksheet Functions | |||
Date Functions | Excel Discussion (Misc queries) | |||
Date functions | New Users to Excel | |||
Date functions | Excel Discussion (Misc queries) |