What kind of optionbuttons did you use?

If you used optionbuttons from the Forms toolbar, put a groupbox around each
group of optionbuttons.

If you used optionbuttons from the control toolbox toolbar, you have to give
each optionbutton in each group 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.)

justaguyfromky wrote:

I am trying to create a list of options inside of excel with 7 different
options, I want each option to have 4 option buttons for a total of 28
option buttons. Every time I click on an option button on one of the other
questions, the previous button pushed becomes "un-selected". How can I
seperate option buttons so that every one on the page does not try to
referece the same cell.

Any help would be appreciated

Thanks

--

Dave Peterson