Excel Option Buttons: getting forced choices per row, not per w/s

J

jdm1051

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.
 
D

Dave Peterson

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
A couple questions BEFORE using Office 365 0
Getting Radio Buttons to work, that are inserted via AutoText 0
how to get the resultsheet from the markslips 0
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
filter result- total row numbers varies 1
A macro to hide rows 5

Top