Hi Everyone ..
I am using the code below to auto input a date once another cell has had a value entered into it.
However .. the code seems to display the date WITH the time.
I have formatted the cells, but if you place your cursor in the cell, the value is the date & the time.
How do I populate cell 'C' with the date only in the format I have specified WITHOUT the time when cell 'B' has a value entered.
Thanks
Tayler
Code
'
'Calculating Date & Time for File Allocation Column B to Column C
'
ActiveSheet.unprotect
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("B5:B605"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yy"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
ActiveSheet.protect