Check Boxes
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. |
Check Boxes
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. |
Check Boxes
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. |
Check Boxes
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 |
Check Boxes
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 |
Check Boxes
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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com