/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 vote266 views1 answer
Vbnet check if string is only symbols
VBA
0 vote284 views1 answer
Excel run macro every 5 minutes
VBA
0 vote272 views1 answer
Vb streamreader
VBA
3 votes285 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote298 views1 answer
Vba add spaces
VBA
0 vote303 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote291 views1 answer
Average vba
VBA
0 vote289 views1 answer
Vba simple quote
VBA
0 vote294 views1 answer
Write listbox to text file vb.net
VBA
1 vote286 views1 answer
Vba optional
VBA