adding a toggle button in Microsoft excel
Add a check box (Form control). If the Developer tab is not available, display it. Display the Developer tab. Click the Microsoft Office Button, and then click Excel Options. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.dd a check box, option button, or toggle button to a worksheet. You can use a check box, option button, or toggle button to indicate either/or (or binary) choices. Add a check box (ActiveX control). If the Developer tab is not available, display it. Display the Developer tab. Click the Microsoft Office Button, and then click Excel Options. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.dd a check box, option button, or toggle button to a worksheet. You can use a check box, option button, or toggle button to indicate either/or (or binary) choices. In Microsoft Excel 2010, to have the Option Button(format control) easily accessible, make sure you add Option Button(form control) to the Quck Access Toolbar. To do this, follow these steps: To create an option button and to assign a macro to it, follow these steps: When you click the option button, the macro will run.1  Click the Microsoft Office Button, and then click Excel Options. 2  Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control) , and then click Add. 3  Click OK.4  Click File and then click Options. Click OK. 2  In Excel 2003, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet. 3  In Excel 2007 and 2010, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet. 4  Select any cell in the worksheet. 1 Click the Microsoft Office Button, and then click Excel Options. 2  Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control) , and then click Add. 3  Click OK. 4  Click File and then click Options. Click OK. 2  In Excel 2003, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet. 3  In Excel 2007 and 2010, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet. 4  Select any cell in the worksheet. Step 4. Click the cell on your worksheet where you want your option button displayed. Step 5. Format or edit your button properties to make it do something when clicked. For example, if you inserted a Form Control option button, right-click it and select “Format Control” from the drop-down menu to edit its properties.lick the type of option button you’d like to insert. Form Control and ActiveX Control are the two main categories. To insert a Form Control option button, click “Option Button” from the list of Form Controls. The names of the buttons appear when you hover the mouse over them. Click the Office button, and then click Excel Options. In the Popular category, select the Show Developer tab in the Ribbon check box. On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Option button.lick the Office button, and then click Excel Options. In the Popular category, select the Show Developer tab in the Ribbon check box. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Toggle Button. Click the Office button, and then click Excel Options. In the Popular category, select the Show Developer tab in the Ribbon check box. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Toggle Button.lick the Office button, and then click Excel Options. In the Popular category, select the Show Developer tab in the Ribbon check box. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Toggle Button. Add an option button (Form control). If the Developer tab is not available, display it. Display the Developer tab. Click the Microsoft Office Button, and then click Excel Options.dd a check box, option button, or toggle button to a worksheet. You can use a check box, option button, or toggle button to indicate either/or (or binary) choices. Add an option button (ActiveX control). If the Developer tab is not available, display it. Display the Developer tab. Click the Microsoft Office Button, and then click Excel Options.dd a check box, option button, or toggle button to a worksheet. You can use a check box, option button, or toggle button to indicate either/or (or binary) choices. 1 Click the Microsoft Office Button, and then click Excel Options. 2  Click the Advanced tab. 3  Click to clear the Show Insert Options buttons check box in the Cut, copy, and paste section, and then click OK. Click the File tab, and then click Excel Options. 2  Click the Advanced tab. 3  Click to clear the Show Insert Options buttons check box in the Cut, copy, and paste section, and then click OK.
Add an option button (Form control). If the Developer tab is not available, display it. Display the Developer tab. Click the Microsoft Office Button, and then click Excel Options.dd a check box, option button, or toggle button to a worksheet.