| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi Check Boxes (Selecting Just One)
Hi;
I'm trying to figure out a way to have multiple checkboxes, but only allowing one box to be selected. So if a user clicks on box "A", then goes and clicks on box "B", box "B" will be selected and box "A" automatically deselected. Any help would be greatly appreciated. Cheers, Kirk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Check Boxes (Selecting Just One)
Private Sub CheckBox1_Click()
CheckBox2.Value = False End Sub Private Sub CheckBox2_Click() CheckBox1.Value = False End Su -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Check Boxes (Selecting Just One)
This is the inherent operation of optionbuttons. Is there some reason you
don't want to use them? -- Regards, Tom Ogilvy "Kirk Lewis" wrote in message m... Hi; I'm trying to figure out a way to have multiple checkboxes, but only allowing one box to be selected. So if a user clicks on box "A", then goes and clicks on box "B", box "B" will be selected and box "A" automatically deselected. Any help would be greatly appreciated. Cheers, Kirk |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Check Boxes (Selecting Just One)
Hi Tom,
I didn't use Option Buttons because I have a series of questions, that have 4 options per question. I can not get the 4 option buttons per question to be independent for each question. So, I figured checkboxes would be the way with something written in VB. Cheers, Kirk "Tom Ogilvy" wrote in message ... This is the inherent operation of optionbuttons. Is there some reason you don't want to use them? -- Regards, Tom Ogilvy "Kirk Lewis" wrote in message m... Hi; I'm trying to figure out a way to have multiple checkboxes, but only allowing one box to be selected. So if a user clicks on box "A", then goes and clicks on box "B", box "B" will be selected and box "A" automatically deselected. Any help would be greatly appreciated. Cheers, Kirk |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Check Boxes (Selecting Just One)
If from the control toolbox toolbar, then you can set the groupname property
for each group of 4. Any common and unique name is fine - such as Question1 Question2 this will cause them to act as independent groups. note the default is the sheetname for example, so by default they all work as one group. -- Regards, Tom Ogilvy "Kirk Lewis" wrote in message om... Hi Tom, I didn't use Option Buttons because I have a series of questions, that have 4 options per question. I can not get the 4 option buttons per question to be independent for each question. So, I figured checkboxes would be the way with something written in VB. Cheers, Kirk "Tom Ogilvy" wrote in message ... This is the inherent operation of optionbuttons. Is there some reason you don't want to use them? -- Regards, Tom Ogilvy "Kirk Lewis" wrote in message m... Hi; I'm trying to figure out a way to have multiple checkboxes, but only allowing one box to be selected. So if a user clicks on box "A", then goes and clicks on box "B", box "B" will be selected and box "A" automatically deselected. Any help would be greatly appreciated. Cheers, Kirk |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Check Boxes (Selecting Just One)
And if you used the option buttons from the Forms toolbar, put a GroupBox (also
from the Forms toolbar) around each group of four. Kirk Lewis wrote: Hi Tom, I didn't use Option Buttons because I have a series of questions, that have 4 options per question. I can not get the 4 option buttons per question to be independent for each question. So, I figured checkboxes would be the way with something written in VB. Cheers, Kirk "Tom Ogilvy" wrote in message ... This is the inherent operation of optionbuttons. Is there some reason you don't want to use them? -- Regards, Tom Ogilvy "Kirk Lewis" wrote in message m... Hi; I'm trying to figure out a way to have multiple checkboxes, but only allowing one box to be selected. So if a user clicks on box "A", then goes and clicks on box "B", box "B" will be selected and box "A" automatically deselected. Any help would be greatly appreciated. Cheers, Kirk -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Selecting Check Boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
