Grouping Checkboxes In Forms

Posted on 2010-01-07
Medium Priority
Last Modified: 2012-05-08
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?
Question by:onlinemathteacher
  • 2
  • 2
LVL 76

Accepted Solution

GrahamSkan earned 500 total points
ID: 26201916
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.

Author Comment

ID: 26203477

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.

Author Closing Comment

ID: 31674076
Thanks !
LVL 76

Expert Comment

ID: 26203851

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question