/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 vote256 views1 answer
Excel vba urlmon
VBA
0 vote268 views1 answer
Excel vba round to whole number
VBA
0 vote227 views1 answer
Vba open report
VBA
5 votes225 views1 answer
Excel vba high word from Long Integer
VBA
0 vote248 views1 answer
Windows Forms dark title bar
VBA
1 vote228 views1 answer
Excel vba saveas force overwrite
VBA
0 vote228 views2 answers
Vb.net include quotes in string
VBA
6 votes236 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote222 views1 answer
Vba parameter adodb null value
VBA
0 vote233 views1 answer
Vba test optional argument
VBA