I'd like to create a check list in Excel that allows the viewer to manually click on a check box to choose certain options. Can someone help me with how to insert a checkbox?
Thank you
View->Toolbars->Control Toolbox. Click on the check-box on the toolbar then click-drag on the spreadsheet to place the new control. Double-click on the control to bring up the VBE where you can add code (by default the double-click will start up a macro to process the Click event for the check box).
There are other ways, of course, but this is probably the easiest. Now, what you do in the CLick macro is up to you and requires some VBA knowledge.
For example, assuming the check box name (by default, when created) is CheckBox1, you can then query the value, which will be true or false:
Code:
Private Sub CheckBox1_Click()
If CheckBox1.Value Then
Range("A1").Value = "yes"
Else
Range("A1").Value = "no"
End If
End Sub
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
