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

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

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,
Kevin
0
AFSTech
Asked:
AFSTech
  • 3
  • 2
1 Solution
 
FlysterCommented:
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
  Else
     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)

Flyster
0
 
AFSTechAuthor Commented:
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?

Kevin
0
 
AFSTechAuthor Commented:
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.  

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

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=806

Hope I saved you some time!

Paul
0
 
AFSTechAuthor Commented:
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.

K.
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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