***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

Excel-User wrote:
>
> 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
>
> --
> Excel-User
> ------------------------------------------------------------------------
> Excel-User's Profile: http://www.excelforum.com/member.php...o&userid=37589
> View this thread: http://www.excelforum.com/showthread...hreadid=572137

--

Dave Peterson

[Scott]

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

"Excel-User" wrote:

>
> 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
>
>
> --
> Excel-User
> ------------------------------------------------------------------------
> Excel-User's Profile: http://www.excelforum.com/member.php...o&userid=37589
> View this thread: http://www.excelforum.com/showthread...hreadid=572137
>
>