M mark Aug 1, 2003 #1 what would the code be to make a checkbox when it is checked it would put the number 2 into a cell
M Mike Tomasura Aug 1, 2003 #2 try this Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1") = "2" Else Range("A1") = "" End If End Sub
try this Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1") = "2" Else Range("A1") = "" End If End Sub