activex checkbox date time stamp

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

sorry, G1 reference is to store username that I forgot to take out, but it is also not important to solve my problem. hanks again to look at my problem

sorry, my first two posts were not very good... Attached is the workbook I started and here's the code I have so far

Please Login or Register  to view this content.