checkbox
 

what would the code be to make a checkbox when it is
checked it would put the number 2 into a cell

checkbox
 

try this


Private Sub CheckBox1_Click()


If CheckBox1.Value = True Then
Range("A1") = "2"
Else
Range("A1") = ""
End If


End Sub



"mark" wrote in message
...
what would the code be to make a checkbox when it is
checked it would put the number 2 into a cell