Please help with formula or VBA

[greenadam1986]

Hello i am trying to use a checkbox to add the current time in one cell and then add a number to another cell.

e.g. cell (B1) 10:31am - cell (C1) 1

then if i untick the checkbox, ti is clear.

can anyone please help.

 

[Scott T]

Assuming it is an active X check box. Create the checkbox and right click and select view code

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range("B1").Value = Time()
If CheckBox1.Value = True Then Range("C1") = 1

If CheckBox1.Value = False Then Range("B1").ClearContents
If CheckBox1.Value = False Then Range("C1").ClearContents
End Sub
End Sub

 

[greenadam1986]

Thank you, it's a big help