Grouping Checkboxes In Forms

Posted on 2010-01-07
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
    LVL 76

    Accepted Solution

    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


    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

    Thanks !
    LVL 76

    Expert Comment


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now