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

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

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

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

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

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