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?

Create 2 group boxes to contain the option buttons.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"chris_za_za" wrote in message
...
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?

Link the two pairs to different cells.

--

HTH

RP

"chris_za_za" wrote in message
...
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.

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



"Rob van Gelder" wrote:

Create 2 group boxes to contain the option buttons.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"chris_za_za" wrote in message
...
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?

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

"Bob Phillips" wrote:

Link the two pairs to different cells.

--

HTH

RP

"chris_za_za" wrote in message
...
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?

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.

"chris_za_za" wrote:

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

"Bob Phillips" wrote:

Link the two pairs to different cells.

--

HTH

RP

"chris_za_za" wrote in message
...
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?

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.

--
Regards,
Tom Ogilvy


"Morlet" wrote in message
...
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.

"chris_za_za" wrote:

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

"Bob Phillips" wrote:

Link the two pairs to different cells.

--

HTH

RP

"chris_za_za" wrote in message
...
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?

Chris,

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

--

HTH

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


"Morlet" wrote in message
...
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.

"chris_za_za" wrote:

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

"Bob Phillips" wrote:

Link the two pairs to different cells.

--

HTH

RP

"chris_za_za" wrote in message
...
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?