ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I start a new sequence of radio buttons? (https://www.excelbanter.com/excel-worksheet-functions/243121-how-do-i-start-new-sequence-radio-buttons.html)

searcherlady

How do I start a new sequence of radio buttons?
 
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

Teethless mama

How do I start a new sequence of radio buttons?
 
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


Dave Peterson

How do I start a new sequence of radio buttons?
 
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

searcherlady

How do I start a new sequence of radio buttons?
 
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



All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com