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

newby wrote:

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!!
--
Thanks!!

--

Dave Peterson