Microsoft Office Forums - View Single Post - [Solved] Show Userform when Content Control CheckBox ticked

derajlance · 05-13-2016, 12:02 PM

I've tried to get this to work every way except the correct way obviously.

I have a Content Control CheckBox on a document. When it is checked, I would like a userform to show.

My most recent attempt to make this happen was using:

Code:

Private Sub Check1_Change()
    Dim objCC_Check1 As ContentControl
    Set objCC_Check1 = ActiveDocument.SelectContentControlsByTag("Check1").Item(1)
    
    If objCC_Check1.Checked = True Then
        UserForm1.Show
    End If
End Sub

When testing this, after entering a check, nothing happens.

Suggestions?