STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL

  • Thread starter Thread starter Asoka Walpitagama - Brandix College IT
  • Start date Start date
A

Asoka Walpitagama - Brandix College IT

Need to store the Date & Time whenever a value is entered to a cell.
If a value is entered to celle B3 then the current date & time should be
saved in C3.

I used the following in cell C3

=IF(B3<>"", NOW()," " )

But whenever any operation is done in a cell the Date & Time gets the
current value which I dont want to happen.

Thanks Asoka
 
You need an event sub for that:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B3" Then
Cells(Target.Row, Target.Column + 1) = Date + Time
End If
End Sub

This works only for B3, post if you want to expand its range or need help to
install it!

Regards,
Stefi

„Asoka Walpitagama - Brandix College IT†ezt írta:
 
Back
Top