Option button

[Guest]

I am currently using 4 option buttons. These 4 buttons are not wanting to
work independantly from each other.

I am wanting 2 for example to select 1 & 2, and the others to select A & B.
These buttons when I link them to a specific cell all change to that cell
and not only the selected ones.

WHAT DO I DO?

 

[Rob van Gelder]

Create 2 group boxes to contain the option buttons.

 

[Bob Phillips]

Link the two pairs to different cells.

 

[Guest]

Thanx Rob, I have tried grouping these items it does not seem to help.

 

[Guest]

Thank you Guys, sometimes it is easier to ask than too look.

 

[Guest]

Hi guys
I have been trying to do like Bob wrote, but I can't seem to get it right.
When I link a pair to a cell the other cells automatically link to the same
cell.
WHY?????? Please help.

 

[Tom Ogilvy]

If the option buttons are from the control toolbox toolbar, give each pair a
single groupname in their properties. It doesn't make any difference what
name you choose. Then link them to the cell underneath the option button.

Use a third cell (visible) which uses a formula to produce the results

=if(A1,1,if(A2,2,""))

=if(A6,"A",if(A7,"B",""))

If from the forms toolbar, you need to put groupboxes around each pair. If
you link one to a cell, the otherone will automatically be linked to that
cell. It will return a numeric result, so you would still need another cell
to produce A and B.

 

[Bob Phillips]

Chris,

Use the grouping control from the forms toolbar to group the pairs.

--

HTH

RP
(remove nothere from the email address if mailing direct)