Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting 3 buttons out of a 3 x 3 array of options.
Hi All,
I have a set of 9 option (radio) buttons arranged in 3 rows by 3 columns. How can I use Excel to control the group of the option (radio) buttons so that only one option can be selected in any row and any column? In other word, I want only 3 buttons to be selected out of the total of 9. Please I will appreciate it if you can help me out in full details. I don't know much about Excel programming. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting 3 buttons out of a 3 x 3 array of options.
On a worksheet?
If you use optionbuttons from the Forms toolbar, put a groupbox (also on that same toolbar) around the optionbuttons. And then rightclick on an optionbutton on that group, choose Format Control|control tab. Then assign the linked cell (if you want). If you use optionbuttons from the control toolbox toolbar, rightclick on each of the members of the group, choose properties, and give that group a unique groupname. You can assign the Linkedcell on that properties window (if you want). Tayo wrote: Hi All, I have a set of 9 option (radio) buttons arranged in 3 rows by 3 columns. How can I use Excel to control the group of the option (radio) buttons so that only one option can be selected in any row and any column? In other word, I want only 3 buttons to be selected out of the total of 9. Please I will appreciate it if you can help me out in full details. I don't know much about Excel programming. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons, Forms Control, Excel 2007 - 3 options | Excel Worksheet Functions | |||
Options of the buttons F1, F2, F4,F5 .... dont'work | Excel Discussion (Misc queries) | |||
Selecting options | Excel Worksheet Functions | |||
selecting using option buttons in excel | Excel Worksheet Functions | |||
Options should provide browse buttons under settings. | Setting up and Configuration of Excel |