software

I would like to add radio or option buttons to a spreadsheet. The options
for them would be Yes, No, and NA for several questions. I can't get the
selection in one question to stay after I select an answer in the following
question. I think it has to do with grouping the buttons, but I can't find
anything in quot;helpquot; on how to do this.

If you used the optionbuttons from the Forms toolbar, then draw a GroupBox
around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)

If you used optionbuttons from the Control toolbox toolbar, then right click on
each and change the groupname. Use a unique groupname for each group of
optionbuttons.

(The default groupname is the sheet name--that's why they're all grouped
together.)

Is this for something like a survey?

Maybe this from Debra Dalgleish would help:
www.contextures.com/xlform01.html
Susan wrote:
gt;
gt; I would like to add radio or option buttons to a spreadsheet. The options
gt; for them would be Yes, No, and NA for several questions. I can't get the
gt; selection in one question to stay after I select an answer in the following
gt; question. I think it has to do with grouping the buttons, but I can't find
gt; anything in quot;helpquot; on how to do this.

--

Dave Peterson

I have tried changing the group name for each set of option buttons following
the directions om quot;helpquot; under the GroupName Property Example as follows:

Sub CNMPFollowup_Initialize()
OptionButton1.GroupName = quot;Yellowstonequot;
OptionButton2.GroupName = quot;Yellowstonequot;
OptionButton3.GroupName = quot;Yellowstonequot;

OptionButton4.GroupName = quot;Yosemite-Group2quot;
OptionButton5.GroupName = quot;Yosemite-Group2quot;
OptionButton6.GroupName = quot;Yosemite-Group2quot;

OptionButton7.GroupName = quot;Brice Canyon-Group3quot;
OptionButton8.GroupName = quot;Brice Canyon-Group3quot;
OptionButton9.GroupName = quot;Brice Canyon-Group3quot;
End Sub

I still don't get the results I'm wanting. Am I doing something wrong? The
form is a follow-up to prescribed farm practices and we're trying to some
feedback of the results.

Thanks for your help.quot;Dave Petersonquot; wrote:

gt; If you used the optionbuttons from the Forms toolbar, then draw a GroupBox
gt; around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)
gt;
gt; If you used optionbuttons from the Control toolbox toolbar, then right click on
gt; each and change the groupname. Use a unique groupname for each group of
gt; optionbuttons.
gt;
gt; (The default groupname is the sheet name--that's why they're all grouped
gt; together.)
gt;
gt; Is this for something like a survey?
gt;
gt; Maybe this from Debra Dalgleish would help:
gt; www.contextures.com/xlform01.html
gt;
gt;
gt;
gt; Susan wrote:
gt; gt;
gt; gt; I would like to add radio or option buttons to a spreadsheet. The options
gt; gt; for them would be Yes, No, and NA for several questions. I can't get the
gt; gt; selection in one question to stay after I select an answer in the following
gt; gt; question. I think it has to do with grouping the buttons, but I can't find
gt; gt; anything in quot;helpquot; on how to do this.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Dave,

I did some more looking around at my option button properties and found
GroupName shown as Sheet 1. I know now that this is where I needed to change
the Group name, not in Visual Basic. I don't know what the code I put in is
supposed to do.

Thanks for your help.

quot;Dave Petersonquot; wrote:

gt; If you used the optionbuttons from the Forms toolbar, then draw a GroupBox
gt; around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)
gt;
gt; If you used optionbuttons from the Control toolbox toolbar, then right click on
gt; each and change the groupname. Use a unique groupname for each group of
gt; optionbuttons.
gt;
gt; (The default groupname is the sheet name--that's why they're all grouped
gt; together.)
gt;
gt; Is this for something like a survey?
gt;
gt; Maybe this from Debra Dalgleish would help:
gt; www.contextures.com/xlform01.html
gt;
gt;
gt;
gt; Susan wrote:
gt; gt;
gt; gt; I would like to add radio or option buttons to a spreadsheet. The options
gt; gt; for them would be Yes, No, and NA for several questions. I can't get the
gt; gt; selection in one question to stay after I select an answer in the following
gt; gt; question. I think it has to do with grouping the buttons, but I can't find
gt; gt; anything in quot;helpquot; on how to do this.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

It uniquely identifies each group of optionbuttons.

So if those groupnames got changed, you should be able to select an option
button in each group without changing the other groups.
Susan wrote:
gt;
gt; Dave,
gt;
gt; I did some more looking around at my option button properties and found
gt; GroupName shown as Sheet 1. I know now that this is where I needed to change
gt; the Group name, not in Visual Basic. I don't know what the code I put in is
gt; supposed to do.
gt;
gt; Thanks for your help.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; If you used the optionbuttons from the Forms toolbar, then draw a GroupBox
gt; gt; around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)
gt; gt;
gt; gt; If you used optionbuttons from the Control toolbox toolbar, then right click on
gt; gt; each and change the groupname. Use a unique groupname for each group of
gt; gt; optionbuttons.
gt; gt;
gt; gt; (The default groupname is the sheet name--that's why they're all grouped
gt; gt; together.)
gt; gt;
gt; gt; Is this for something like a survey?
gt; gt;
gt; gt; Maybe this from Debra Dalgleish would help:
gt; gt; www.contextures.com/xlform01.html
gt; gt;
gt; gt;
gt; gt;
gt; gt; Susan wrote:
gt; gt; gt;
gt; gt; gt; I would like to add radio or option buttons to a spreadsheet. The options
gt; gt; gt; for them would be Yes, No, and NA for several questions. I can't get the
gt; gt; gt; selection in one question to stay after I select an answer in the following
gt; gt; gt; question. I think it has to do with grouping the buttons, but I can't find
gt; gt; gt; anything in quot;helpquot; on how to do this.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson