checkbox

M

mark

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

try this


Private Sub CheckBox1_Click()


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


End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Anything will help 0
Beginner - Click a checkbox then calculation to be done automatically 1
Creating a checklist with predefined comments 1
Arrays and Checkboxes 3
How to create bulleted to-do list using two styles? 5
check box 1
auto added checkbox 2

Top