Static dates
Closed
jaddiso
Posts
1
Registration date
Wednesday September 17, 2014
Status
Member
Last seen
September 22, 2014
-
Sep 22, 2014 at 09:00 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2014 at 03:53 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2014 at 03:53 AM
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 23, 2014 at 03:53 AM
Sep 23, 2014 at 03:53 AM
right click tab of sheet1 (where the data is entered)
click "view code"
in the window that comes up copy this event code and save the file
now when you enter any datae in a3 nothing happens
if you enter some data in A4 it is reflected in D4 also.
click "view code"
in the window that comes up copy this event code and save the file
now when you enter any datae in a3 nothing happens
if you enter some data in A4 it is reflected in D4 also.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
If Target.Row < 4 Then Exit Sub
Application.EnableEvents = False
Cells(Target.Row, "D") = Target
Cells(Target.Row, "D").NumberFormat = "mm/dd/yy"
Application.EnableEvents = True
End Sub
