Tuesday, February 19, 2013

How to Use Radio Buttons in Excel


Using Radio Buttons in Excel 2003
1. Open the worksheet to which you want to add radio buttons. Open the 'Control Toolbox' by going to the 'View' menu, pointing to 'Toolbars' and selecting 'Control Toolbox.' The toolbox appears as a floating toolbar.
2. Click the radio button control in the 'Control Toolbox.' If you are not sure which control this is, hover your mouse over each button in the 'Control Toolbox' and click on the one that says 'Option Button.'
3. Click onto the worksheet where you want to place the first radio button and drag the box to 'draw' the size you want it to be.
4. Right-click the radio button, point to 'Option Button Object' and click 'Edit.' Delete the 'Option Button' text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.
5. Right-click the radio button and select 'View Code' to add a macro to the radio button. Right-click the radio button and select 'Properties' to change other properties of the button. Click the 'Exit Design Mode' button in the 'Control Toolbox' to leave design mode and enable the radio button.
Using Radio Buttons in Excel 2007
6. Display the 'Developer Tab.' Click the 'Office Button' and click 'Excel Options.' Select the 'Show Developer Tab in the Ribbon' check box under 'Top Options for Working With Excel' and click 'OK.'
7. Go to the 'Developer' tab and click 'Insert' in the 'Controls' group. Click 'Option Button' under 'ActiveX Controls.'
8. Click onto the Excel worksheet and drag the mouse to draw the radio button onto the page.
9. Click 'Design Mode' in the 'Controls' group of the 'Developer' tab. Right-click the radio button, point to 'Option Button Object' and click 'Edit.' Delete the 'Option Button' text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.
10. Right-click the radio button and select 'View Code' to add a macro to the radio button. Right-click the radio button and select 'Properties' to change other properties of the button. Click the 'Exit Design Mode' button in the 'Control Toolbox' to leave design mode and enable the radio button.

Blogger news