Add a check box, option, or Toggle button (ActiveX controls)

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.

Example of an ActiveX check box control
Check box (ActiveX control)

Example of an ActiveX option button control

Option button (ActiveX control)

Example of an ActiveX toggle button control

Toggle button (ActiveX control)

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 Office button image > Excel Options > Popular > Show Developer tab in the Ribbon.

  1. To add a check box, click the Developer tab, click Insert, and under ActiveX Controls, click Button image .

    To add an option button, click the Developer tab, click Insert, and under ActiveX Controls, click Button image .

    To add a toggle button, click the Developer tab, click Insert, and under ActiveX Controls, click Button image .

  2. 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.

  3. To edit the ActiveX control, make sure that you are in design mode. On the Developer tab, in the Controls group, click Design Mode.

  4. 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

  1. To format a control, right-click the control, and then click Properties.

  2. In the Properties dialog box, modify a property as necessary.

Deleting a control
  • Right-click the control, and press DELETE.

See Also

Add a check box or an option button (Form controls)

Overview of forms, form controls, and ActiveX controls on a worksheet

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×