I would like to add/update date/time stamp when a checkbox is clicked/unclicked for "done" [A1] or "not applicable" [B1] so the cells [E1:G1] would store only the last update. This is what I have for now but I'm positive that a more elegant solution is out there using intersect or target... My poor attempt for the first checkbox is here and I hope to expand it to 100+rows and 2 columns
Private Sub CheckBox1_Click()
If ((E1 = "") Or (F1 = "") Or (G1 = "")) Then
If ((CheckBox1.Value = True) Or (CheckBox1.Value = False)) Then
Sheet5.Range("E3").Value = Date
Sheet5.Range("F3").Value = Time
End If
End If
If ((E1...
End Sub
Bookmarks