***Important*** Question about check boxes

[Excel-User]

Hi,

I have created a survey in Excel which will be sent via email to a lot
of respondents. The survey contains a lot of questions and for each
question, they can tick a check box on a scale from 1 to 10 (10 check
boxes for each question). How can I enter a validation that only one
checkbox may be ticked? What can I do to avoid that users are ticking 2
check boxes (or more) for the same question - only one answer may be
given? Can I make use of a po-up as a warning? Or maybe something
else?

Please help!

Thanks!

Cheers,
Excel-user

 

[Phatchef24]

Why not use a Combo box or a list box? If you use the Form Combo box
you can have the value that the respondent selects mapped to any cell
that you want in the spreadsheet. Just seems easier to do it that way
that & they'll be forced to pick only 1 answer.

 

[Dave Peterson]

It sounds like you should use optionbuttons instead of checkboxes. If the
optionbuttons are grouped nicely, you can only select one of the group.

You may want to see one way of implementing optionbuttons from the Forms toolbar
(from Debra Dalgleish's site):

http://www.contextures.com/xlForm01.html

 

[Guest]

Hello,

just have a criteria (on checkbox_click) that says something like
ex.
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
CheckBox2.Enabled = False
CheckBox3.Enabled = True
CheckBox4.Enabled = True
Else
CheckBox2.Enabled = True
CheckBox3.Enabled = False
CheckBox4.Enabled = False
endif
end sub

this just makes it so that when checkbox1 is true then checkbox 2 is
disabled and 3 and 4 are enabled. If it's false then 2 is enabled, 3+4 are
disabled. this worked fine on a userform, I would imagine this would also
work in a normal excel worksheet. Good luck

Cheers,

Scott