Forum Discussion
Adding a button for financial balance
Option Button
Open Excel and Click on "Developer" Tab
Open Excel and click on the "Developer" tab. If it’s not visible, click “File,” “Options” and then “Customize Ribbon.” Click the “Developer” check box within the Main Tabs list and click the "OK" button when you’re finished.
Select "Insert"
Select “Insert” from the Controls group on the Developer tab.
Choose the Type of Button
Click 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. To insert an ActiveX Control option button, click “Option Button” from the list of ActiveX Controls.
Click the Cell on Your Worksheet
Click the cell on your worksheet where you want your option button displayed.
Format the Button
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. If you inserted an ActiveX Control button, right click your button and select “Properties" from the drop-down menu.