Radio Buttons in Excel 2007

  • Thread starter Thread starter newby
  • Start date Start date
N

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!!
 
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?
 
That's the nature of radio buttons by default. They're for ONE choice.
Perhaps you really want check boxes.
 
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
 
Back
Top