/VBA/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

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

Source: stackoverflow.com

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

If Target.Column = 2 And Target.Offset(0, 3).Value = "" Then

Source: stackoverflow.com

Similar codes

0 vote128 views2 answers
Excel vba prevent save
VBA
0 vote134 views1 answer
Vba leading zeros in string
VBA
0 vote140 views1 answer
How to mount floppy disks in vb.net
VBA
1 vote123 views1 answer
Vba compile error object required
VBA
8 votes215 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote145 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote131 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote143 views1 answer
Show unix time in vba
VBA
1 vote126 views1 answer
Excel format cell as kilowatts
VBA
1 vote137 views1 answer
How to check is the value enterd is a number or text in vba
VBA