1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

How To Update Date And Time Automatically Once Id Is

[Solved] How To Update Date And Time Automatically Once Id Is | Vb - Code Explorer | yomemimo.com
Question : how to update date and time automatically once id is entered in excel vba

Answered by : rajesh-thevar

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 : https://stackoverflow.com/questions/24170379/excel-formula-which-places-date-time-in-cell-when-data-is-entered-in-another-cel | Last Update : Thu, 24 Sep 20

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

Answered by : rajesh-thevar

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

Source : https://stackoverflow.com/questions/24170379/excel-formula-which-places-date-time-in-cell-when-data-is-entered-in-another-cel | Last Update : Thu, 24 Sep 20

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

Code Explorer Popular Question For Vb