I have MS Excel 2003 and I am trying to add 2 separate series of 2 radio
buttons each within a single spreadsheet. What I am finding is that all four
radio buttons are tied together and only 1 of the four can be chosen at a
time. How do I break this single series of 4 radio buttons into 2 series of
2 radio button each?
--
searcherlady

You have to use Group Box Form Control around the radio buttons to seperate
each series


"searcherlady" wrote:

I have MS Excel 2003 and I am trying to add 2 separate series of 2 radio
buttons each within a single spreadsheet. What I am finding is that all four
radio buttons are tied together and only 1 of the four can be chosen at a
time. How do I break this single series of 4 radio buttons into 2 series of
2 radio button each?
--
searcherlady

Saved from a previous post (similar to your question):

If your optionbuttons are from the Forms toolbar, the put all 4 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

searcherlady wrote:

I have MS Excel 2003 and I am trying to add 2 separate series of 2 radio
buttons each within a single spreadsheet. What I am finding is that all four
radio buttons are tied together and only 1 of the four can be chosen at a
time. How do I break this single series of 4 radio buttons into 2 series of
2 radio button each?
--
searcherlady

--

Dave Peterson

Thank you, this was very helpful.
--
searcherlady


"Dave Peterson" wrote:

Saved from a previous post (similar to your question):

If your optionbuttons are from the Forms toolbar, the put all 4 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

searcherlady wrote:

I have MS Excel 2003 and I am trying to add 2 separate series of 2 radio
buttons each within a single spreadsheet. What I am finding is that all four
radio buttons are tied together and only 1 of the four can be chosen at a
time. How do I break this single series of 4 radio buttons into 2 series of
2 radio button each?
--
searcherlady

--

Dave Peterson