Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Option Buttons: getting forced choices per row, not per w/s
MS Excel 2002.
Test questions are in consecutive rows in Col B. Two option buttons are in corresponding row in Col B. I want user to have forced choice of one per row, but Excel is allowing only one choice per the whole worksheet. |
#2
|
|||
|
|||
What kind of optionbuttons did you use?
If you used optionbuttons from the Forms toolbar, put a groupbox around each pair of optionbuttons. If you used optionbuttons from the control toolbox toolbar, you have to give each optionbutton in each pair a unique groupname (under properties for each optionbutton). (They default to the name of the worksheet, so that's why they're all "grouped" together.) jdm1051 wrote: MS Excel 2002. Test questions are in consecutive rows in Col B. Two option buttons are in corresponding row in Col B. I want user to have forced choice of one per row, but Excel is allowing only one choice per the whole worksheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't Excel buttons show separately on the taskbar? | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) | |||
Option Buttons in Group Box | Excel Discussion (Misc queries) | |||
What happened to Subscript and Superscript Buttons in Excel? | Charts and Charting in Excel | |||
Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions |