• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Grouping Checkboxes In Forms

I have a WORD form with multiple choice questions on it.  The questions are followed by checkboxes where the student picks an answer.  I have code in Excel that processes the WORD form  to see if the student selects the right answer, and code that looks to see if the student selects more than one answer.  If they choose more than one answer, then no credit would be given.

It would be better to have code in the WORD form that does not allow the student to pick more than one answer.  If they pick a second checkbox, then the first one they select has to be erased somehow.

Can this be done using vba?
0
onlinemathteacher
Asked:
onlinemathteacher
  • 2
  • 2
1 Solution
 
GrahamSkanRetiredCommented:
I thought that Flyster had given you some code do that. For myself I have spent many hours trying the achieve radio button simulation with checkboxes, and there always seemed to be a circumstance where there were no, or more than one, boxes checked.

If you want to force one answer only, you could use a dropdown with, say " ", "A", "B",  "C" entries.

Alternatively, you could consider an ActiveX option button. You can access them when the document is forms-protected.
0
 
onlinemathteacherAuthor Commented:
Thanks.

Guess I need to review the capablilities of the various controls.  

I did a quick look, don't see anything from flyster.  I do see how a pull down could be used, I could do that.  I'll have to read up on the ActiveX option you mention.
0
 
onlinemathteacherAuthor Commented:
Thanks !
0
 
GrahamSkanRetiredCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now