I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

use a radio button instead of a checkbox
--
Allllen


"Steve-Westlake" wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

That works good but I need a yes and no radio that works as a pair because
each excel line will have its own yes/no radio but when I put them into my
worksheet, I can only get 1 out any radio.

Example:

B9 has a yes/no radio
B10 has a yes/no radio
B11 has a yes/no radio ...... you can see the pattern

But when I select say B9 yes then goto b10 and select no, i loose the B9
entry. I want each line to be seperate.

Thank you




"Allllen" wrote:

use a radio button instead of a checkbox
--
Allllen


"Steve-Westlake" wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

First, if you're only allowing Yes and No, just use a single checkbox that
represents Yes. If it's unchecked, then that means No.

But if you want to use two objects, you can use two option buttons.

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Steve-Westlake wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

--

Dave Peterson

Excelent. Thank you for your help. When I set the groupnames the way i wanted
them to be, I then created a copy of the master sheet but the new sheets
radios are still "linked" to the origianl page. Is there a quicker way than
changing each radio manually for each copied page? I've created everything
via the control toolbox.

Thank you for your time and help,
Steve


"Dave Peterson" wrote:

First, if you're only allowing Yes and No, just use a single checkbox that
represents Yes. If it's unchecked, then that means No.

But if you want to use two objects, you can use two option buttons.

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Steve-Westlake wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

--

Dave Peterson

You could use a macro.

Debra Dalgleish shares one that you could review:
http://contextures.com/xlForm01.html

===
As a user, I think I'd find the single checkbox per row more standard.

If you look and Excel's Tools|Options|View tab, you'll notice that the single
checkbox is used a lot.

Steve-Westlake wrote:

Excelent. Thank you for your help. When I set the groupnames the way i wanted
them to be, I then created a copy of the master sheet but the new sheets
radios are still "linked" to the origianl page. Is there a quicker way than
changing each radio manually for each copied page? I've created everything
via the control toolbox.

Thank you for your time and help,
Steve

"Dave Peterson" wrote:

First, if you're only allowing Yes and No, just use a single checkbox that
represents Yes. If it's unchecked, then that means No.

But if you want to use two objects, you can use two option buttons.

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Steve-Westlake wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.

--

Dave Peterson


--

Dave Peterson