Friday, July 6, 2012
It is Good to have Options
In this post I thought it was a good time to “Walk on the Wild Side” a little bit, and look at the (surprisingly easy) use of Option Buttons.
Option Buttons have several applications, and can be especially useful in creating Quizzes or Polls in Excel. There are a number of steps, but I guarantee that it will be well worth it if you hang in there and give them a try!
Here is how you do it:
1. Make sure the Developer tab is visible on your toolbar (available in Excel Options)
2. Under the Developer tab, choose Insert / Option Button (Form Control)
3. Draw the Option Button box on your worksheet and repeat for however many buttons you wish to have for choices
4. Now, (this is Very Important), to make the buttons work together, return to your Insert dropdown and choose Group Box (Form Control)
5. Then draw your Group Box all the way around your Option Buttons
Just Three More Steps and We’re There!
6. Right-Click one of the Option Buttons, choose Format Control from the dropdown and select a Cell Link that you want your Option Buttons to populate
7. Now is where the Fun really begins. Create a Formula that is based on the value that is shown in the Cell Link
8. For example, let’s say you have linked three Option Buttons to cell $A$1 and you wanted Option 3 to return a “Correct” response and the others to return “Incorrect”, here is what you do:
In cell A2, type =IF(A1=0,"", IF(A1=3, "Correct!", "Incorrect"))
Now when the user chooses Option 3 of the three possible, they are rewarded with the “Correct” feedback. Option Buttons, give them a try; It is always good to have options…