You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice. Toggle buttons indicate a state between an enabled or disabled state when the button is clicked.
To add an ActiveX control, you’ll need the Developer tab on your Ribbon.
Notes: To enable the Developer tab, follow these instructions:
-
In Excel 2010 and subsequent versions, click File > Options > Customize Ribbon , select the Developer check box, and click OK.
-
In Excel 2007, click the Microsoft Office button
-
To add a check box, click the Developer tab, click Insert, and under ActiveX Controls, click
To add an option button, click the Developer tab, click Insert, and under ActiveX Controls, click
To add a toggle button, click the Developer tab, click Insert, and under ActiveX Controls, click
-
Click in the cell wherever you want to add the control.
Tip: You can only add one checkbox or option button at a time. To speed things up, after you add your first control, right-click it and select Copy > Paste.
-
To edit the ActiveX control, make sure that you are in design mode. On the Developer tab, in the Controls group, click Design Mode.
-
To set the control properties, on the Developer tab, in the Controls group, click Properties.
You can also right-click the control, and then click Properties.
The Properties dialog box appears. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help topic. You can also type the property name in the Visual Basic Help Search box. For more information on properties, also see Properties (Microsoft Forms) on MSDN.
Formatting a control
-
To format a control, right-click the control, and then click Properties.
-
In the Properties dialog box, modify a property as necessary.
Deleting a control
-
Right-click the control, and press DELETE.
