98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Going Against The Grain With Multiple Radio Buttons In Excel
Fri 23rd September 2011
The difference between a radio button (also called an option button) and a check box is that, where multiple check boxes can be selected, only one radio button can be chosen from a group. Stan discovers that when he attempts to select a second radio button from the group, this cancels his original selection. He reluctantly looks towards using check boxes to show the details, but he really wanted to use radio buttons because of the football shape.
It is possible for Stan to get his wish and display radio buttons, but it does require a different approach and the buttons will not work in the conventional way. These buttons will be for display purposes only and not there to allow the user to make a choice.
The usual way to insert a radio button is via the Forms option from Toolbars in the View menu. To create multiple buttons Stan would need to go to View and select Toolbars and then Control Toolbox from the menu.
The next stage would be to click on the radio button icon and add one button for each penalty kick taken by the first team. For this example we will stick to a standard five, as this shootout did not go to sudden-death. It is here that Stan notices a difference between these radio buttons created via the Control Toolbox, and those from the Forms menu. Basically, these radio buttons appear not to work, as they do not respond to the cursor.
By default, Excel groups radio buttons together, so the first thing Stan must do is to separate each button into its own group. To do this he right clicks on the button and selects Properties. Under the Alphabetic tab he goes to GroupName, and he changes this to Player1. He names the next one Player2 and so on until each button has its own name.
Now Stan goes back to the first radio button, which was a goal and so requires a black dot inside He right clicks on this and once again selects Properties from the list to open up the Properties sheet. This time he selects the Alphabetical tab, and at the bottom of the Appearance area in the Value section, Stan deletes the value False and types in True. This will change the circular button from empty to filled. Stan repeats this process in each of the buttons where a goal was scored.
Finally Stan adds the surname of each player to the buttons. Starting at the first one again, he right clicks and selects ObjectButton Object and then Edit. This will allow him to delete the existing text and type in his own for each button. And that is it - Stan has multiple radio buttons for his penalty shoot-out record.
This is a rather drawn out process to achieve fairly basic results, but the Properties sheet that opens up is worthy of exploration and experiment. Radio buttons may be football shaped, but Stan would have saved himself a lot of work if he had just used check boxes.
Author is a freelance copywriter. For more information on excel courses london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1969-going-against-grain-with-multiple-radio-buttons-in-excel.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsStudent James Cleverly Excel Introduction As a recent university graduate about to enter a world of job-hunting, this course has been fantastic! I can now go to potential future employers confident that I have a good grasp of the basic excel concepts and skills. The content was great and the instructor was brilliant. A massive thank you! National Treatment Agency
Senior Communications Officer Alex Grover Upgrade to Office 2007 None - some of the best most easily understandable training i've had Casio Electronics Company Ltd
Head Of EMI Neil Evans Excel Intermediate Very useful - Well explained. The course is broken down into Clear and logical exercises. Enjoyed the training..... |
PUBLICATION GUIDELINES