Auto Populate Check Boxes when one check box is checked in Word 2010

Posted on 2012-09-13
Medium Priority
Last Modified: 2012-09-17
Hey all,

I have a large document that uses Bookmarks and REF to auto populate text fields in Word 2010.  I am wondering if word can also auto populate check boxes so that when I check a box on the first page, all the check boxes with the same bookmark will also be checked.  

It would be great if it didn't require a macro to make this happen...

Any thoughts?

Thank you,
Question by:AFSTech
  • 3
  • 2
LVL 22

Accepted Solution

Flyster earned 1500 total points
ID: 38397391
I don't know if you would be able to identify a checkbox by which bookmark it falls under, but you can put code in your first checkbox which would change the rest. In design mode, right-click your first page checkbox and select View Code. Enter this code:

 Private Sub CheckBox1_Click()

  If Me.CheckBox1.Value = True Then
     Me.CheckBox2.Value = True
     Me.CheckBox3.Value = True
     Me.CheckBox4.Value = True
     Me.CheckBox5.Value = True
     Me.CheckBox2.Value = False
     Me.CheckBox3.Value = False
     Me.CheckBox4.Value = False
     Me.CheckBox5.Value = False
  End If

End Sub 

Open in new window

Change the Checkbox names to match yours (If your first page checkbox is not CheckBox1, change both Private Sub Checkbox1_Click() and If me.CheckBox1 to match)


Author Comment

ID: 38399023
This all seems great but I do not see the View Code when I right click on the check box.  I am in design mode but I can't see that anywhere.  I tried to hit ALT F9 and it doesnt show that way either.  I am using Word 2010, possibly it's moved somewhere?


Author Comment

ID: 38399145
Ah nevermind they have to be Active X CheckBoxes as opposed to the Legacy Form Check Boxes.  

Thank you for the help and the code above I am going to have to replace all the checkboxes on the form so im off to work.  

LVL 22

Expert Comment

ID: 38399261
I was just looking into how to program Legacy checkboxes. Before you make any changes, you might want to review this article:


Hope I saved you some time!


Author Comment

ID: 38405493
Thanks again, that is the solution I will go with I think, changing the form is so time consuming because it is a tightly formatted document and the sizes of the form checkboxes and the active x checkboxes are so different.  

I was trying to stay away from using macros in the document but I think that I will just go ahead and accept that the document needs macros and use them for a couple other functions as well.


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

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

839 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