Not clear what you're saying, however, checkboxes are usually "linked" to
cells, and each checkbox should have its own cell link. These each return
TRUE/FALSE. But, as you stated, this allows you to select both which you
don't want.
Option buttons (radio buttons) are all linked to the same cell, and return a
value of which radio button was selected, so if there are 5 radio buttons,
the value of the one linked cell would be 1 to 5. You CAN "group" radio
buttons, so that one group work together and a second group work together,
but in that case you need to put the group inside a frame, or group box (and
make sure the option button doesn't "bleed" onto the worksheet or it will be
treated as the worksheet group, not the groupbox group.
Lastly, if you create option buttons from the Control toolbox instead of the
Forms tools, you can assign a set of the option buttons to have the property
of Groupname be a particular value, like Group1, and another set to be
Group2, and then they will also work independently.

HTH
Bob Umlas
Excel MVP

"shezzer_1972" wrote in message
...
Problem: I have two columns which each has a check box. I want only one
check post to be selected as the two are related i.e.

which contractor will you use contractor 1
contractor 2
who has best rates contractor 1
contractor 2
etc
etc

when I use radio buttons for some strange reason it only ever allows me to
check on radio button on the spreadsheet (could be stupid user syndrome!).
Can anyone help with the best way to work this.

thanks