/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 vote155 views1 answer
Open application from vbnet
VBA
0 vote164 views1 answer
Remove last 8 characters from string vb
VBA
0 vote213 views1 answer
Vba excel do not recalculate before save
VBA
0 vote172 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote173 views1 answer
Vbnet line chart showing extra space
VBA
0 vote212 views1 answer
Excel vba protect content
VBA
0 vote164 views1 answer
Vba shape transparent
VBA
0 vote162 views1 answer
Excel vba clear filter
VBA
1 vote169 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote170 views1 answer
How to get the value of optionbutton in vba
VBA