Option buttons for more than 1 question

[Wayne]

I would like to set up a spread sheet with many questions
to which each can be answered with only True, False, or I
don't know by clicking on the relevant option. I want to
ensure only one response per question is completed.

To do this, I attempted using the option buttons but they
all want to link to one cell.

How do I have resolve this?

Please help.

Wayne

 

[Dave Peterson]

If you used optionbuttons from the forms toolbar, put a groupbox (from the same
toolbar) around each group.

If you used the optionbuttons from the control toolbox toolbar, you'll have to
rightclick on each and assign a nice unique groupname to each member of the
group. (The default is the sheetname--so they're all grouped together.)