Word: Remove content when UserForm CheckBox is unchecked. VBA

[JamesHayek]

Hello All!

I am using Bookmarks and a UserForm to populate data in Word. My apologies if this is on the wrong forum. I am using VBA and assumed it is similar.

After setting my bookmarks and creating a user form, I can populate text in my word document with the following:

Private Sub WSP01_700LTE_Click()


If Me.WSP01_700LTE.Value = True Then
    Set oRng05 = ActiveDocument.Bookmarks("Freq01a").Range
    oRng05.Text = "700 LTE"
    ActiveDocument.Bookmarks.Add "Freq01a", oRng05
End If
    
End Sub

Where WSP01_700LTE is my checkbox name and Freq01a is my bookmark.
The line oRng05.Text = "700 LTE" will populate the Word document with 700 LTE

But what if I want that line removed if the check box is unchecked?


Thanks in advance!

 

[Macropod]

And what do you expect to happen if the user re-checks the checkbox - or is there a process that exits the userform so the deletion, if appropriate, can be done then?

 

[JamesHayek]

If the user toggles the checkbox, I expect nothing to happen. The only time anything happens, based on the options, is when the form is submitted using the enter button.

I do not expect the user to reopen the UserForm once competed.

 

[Macropod]

If the user toggles the checkbox, I expect nothing to happen. The only time anything happens, based on the options, is when the form is submitted using the enter button.

Presumably, then, WSP01_700LTE_Click is not the Sub corresponding to the 'Enter' button, whatever that is. What is that sub?

Also, what title or tag does your content control have?