Grouping Option Buttons
 

I am trying to set up two lists with option buttons in the same
spreadsheet. The first list is working great, but when I started
building the second list, it has become part of the first list. (i.e.
If I click on the first list of five buttons, they have an assigned
value of 1-5. When I click on the second list, it goes to 6-10.) I
can't get them to function independently.

Please help.

P.S. I'm using the "forms" option button.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Grouping Option Buttons
 

You have to put a groupbox around each group to get independent behavior.
You will need to go to at least on option button in each group and assign it
to the appropriate cell.

--
Regards,
Tom Ogilvy

m@_ wrote in message
...
I am trying to set up two lists with option buttons in the same
spreadsheet. The first list is working great, but when I started
building the second list, it has become part of the first list. (i.e.
If I click on the first list of five buttons, they have an assigned
value of 1-5. When I click on the second list, it goes to 6-10.) I
can't get them to function independently.

Please help.

P.S. I'm using the "forms" option button.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Grouping Option Buttons
 

Tom Ogilvy wrote:
*You have to put a groupbox around each group to get independent
behavior.
You will need to go to at least on option button in each group and
assign it to the appropriate cell.

--
Regards,
Tom Ogilvy

*

Thank you, this is a problem I'm having also. But how do you assign one
option button in each group, to an appropriate cell?

Thank you for your time, Chris


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Grouping Option Buttons
 

These are optionbuttons from the Forms toolbar.

Just right click on one of the buttons within the groupbox and select Format
Control. Then Control Tab, then give it a nice cell link.

Then try it with another button within the same groupbox. You'll see it's
already got a cell link.



mrpayroll wrote:

Tom Ogilvy wrote:
*You have to put a groupbox around each group to get independent
behavior.
You will need to go to at least on option button in each group and
assign it to the appropriate cell.

--
Regards,
Tom Ogilvy

*

Thank you, this is a problem I'm having also. But how do you assign one
option button in each group, to an appropriate cell?

Thank you for your time, Chris

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson