Radio Buttons in Excel 2007

[newby]

I am fairly new at using radio buttons. Finally found them through the
Developer Ribbon. Having trouble getting them to work as we would like them
to. We want them to appear in two seperate cells. I've got them placed, but
currently, if you have one clicked in on cell and go the next to click on one
of the choices, it deletes the one from the previous cell. Any suggestion on
how to get this option to work or on to use another form to accomplish our
goal. I appreciate your help!!

 

[Bernard Liengme]

If I understand you: what I do is
a) use Forms Controls rather than Active-X
b) begin by placing a Group control on the worksheet
c) add the radio buttons to the Group
Any use?

 

[Bob Umlas]

That's the nature of radio buttons by default. They're for ONE choice.
Perhaps you really want check boxes.

 

[Dave Peterson]

Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this). Each group should have its own unique groupname.

If you're creating a survey form, you may want to look at Debra Dalgleish's
site:
http://contextures.com/xlForm01.html