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

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