MS Word VBA CheckBoxes

[Redmondkw357]

thread711-1792711

Redmondkw357 (TechnicalUser)
(OP)
12 Feb 19 00:08
I have a checkbox that I use the following code to change the properties but I would like it to apply to all checkboxes or any new checkboxes added to the document without having to copy it to each individual check box click event.

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
CheckBox1.Caption = "Complete"
CheckBox1.BackColor = 65535
CheckBox1.ForeColor = 25600
CheckBox1.SpecialEffect = fmButtonEffectSunken
Else
CheckBox1.Caption = "Status"
CheckBox1.BackColor = 16777215
CheckBox1.ForeColor = 255
CheckBox1.SpecialEffect = fmButtonEffectSunken
End If
End Sub

Can someone tell me how to make this apply to any checkbox and all new checkbox at one time?

 

[Andrzejek]

You may try this - not tested because I don't know if you have your check boxes on the Form, in the Word document, on the Excel sheet, ...

Private Sub CheckBox1_Click()

    Call DealWithIt(CheckBox1)

End Sub

Private Sub DealWithIt(ByRef chk As CheckBox)

With chk
    If .Value = True Then
        .Caption = "Complete"
        .BackColor = 65535
        .ForeColor = 25600
        .SpecialEffect = fmButtonEffectSunken
    Else
        .Caption = "Status"
        .BackColor = 16777215
        .ForeColor = 255
        .SpecialEffect = fmButtonEffectSunken
    End If
End With

End Sub

---- Andy

There is a great need for a sarcasm font.

 

[Redmondkw357]

I apologize, I should have noted which MS application this was for. I am using the check boxes in MS Word 2016.

 

[Redmondkw357]

Will this apply to all check boxes on the document or do I have to add it to each check box?

 

[Andrzejek]

I am using the check boxes in MS Word 2016" on the UserForm? Or on the Word document itself?

Oh, wait, you did state "all check boxes on the document ", so it is not on the UserForm.

"Will this apply to all check boxes on the document or do I have to add it to each check box? " That depends on what action you want to make and what you want to happen.

If you want to click on one check box and want to change the appearance of this particular check box, then add the Call to all your check boxes.

Otherwise you would need to loop thru all check boxes, but that is not making much sense.

It would help if you would show a picture of what you have, and state clearly what action you want to make and what you would like to happen.


---- Andy

There is a great need for a sarcasm font.

 

[Redmondkw357]

Here is a screen print, note, the first changed check box, I would like the coding behind the first check box to apply to all check boxes on the document without having to enter it into the click event for each new check box if possible.

https://files.engineering.com/getfi...45-5528-459d-8be9-9cb8eb75519b&file=Case.docm

 

[sxschech]

This worked on my word file.

to apply to all checkboxes or any new checkboxes added

To get the number of checkboxes

[tt]activedocument.ContentControls.Count[/tt]

https://docs.microsoft.com/en-us/office/vba/api/word.contentcontrols.count

If new boxes are added or removed, the count will adjust accordingly. Then you could use that in your loop.

For i = 1 to activedocument.ContentControls.Count
      activedocument.contentcontrols(i).____________

Next

Put the action you want in the underlined part

 

[Redmondkw357]

Thank you, I will try this and let you know the results hopefully after this next meeting.

 

[macropod]

If you want something to apply to all checkboxes on a document, you should use content control checkboxes. Your code implies an ActiveX checkbox. With content control checkboxes, a single ContentControlOnExit macro can respond the same way for all of them. See, for example:

http://www.msofficeforums.com/word-...checkboxes-calculating-results.html#post33489

http://www.msofficeforums.com/word-...control-checkbox-calculations.html#post107008

Do note, though, that content control checkboxes don't have the same properties as ActiveX checkboxes.

Cheers
Paul Edstein
[MS MVP - Word]