how to update date and time automatically once id is entered in excel vba how to update date and time automatically once id is entered in excel vba

The solution for “how to update date and time automatically once id is entered in excel vba how to update date and time automatically once id is entered in excel vba” can be found here. The following code will assist you in solving the problem.

If Target.Column = 2 And Target.Offset(0, 3).Value = “” Then
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Offset(0, 3).Value = “” Then
Target.Offset(0, 3) = Format(Now(), “HH:MM:SS”)
End If
End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts