Hi everyone,
I have some code that display date and time in a cell when "done" is input into the adjaecent cell. (Any value would be the trigger, though)
Can this be altered so that when "done" is deleted in the adjaecent cell the time/date is removed. At the moment you have to do it manually.![]()
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Cells.Count = 1 And Target.Column = 7 Then Target.Offset(0, 1) = Now End If End Sub
Thanks in advance
Bookmarks