Multi Check Boxes (Selecting Just One)

[Kirk Lewis]

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

 

[Langy]

Private Sub CheckBox1_Click()

CheckBox2.Value = False

End Sub


Private Sub CheckBox2_Click()

CheckBox1.Value = False

End Su

 

[Tom Ogilvy]

This is the inherent operation of optionbuttons. Is there some reason you
don't want to use them?

 

[Kirk Lewis]

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]

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.

 

[Dave Peterson]

And if you used the option buttons from the Forms toolbar, put a GroupBox (also
from the Forms toolbar) around each group of four.