Need help in content control

elaineAda · #1 04-15-2022, 08:53 PM

I have many content control boxes in my form. Can a macro help in ensuring all the content control boxes are completed before the user save the file?

macropod · #2 04-16-2022, 06:59 AM

For example:

Code:

Private Sub AutoClose()
Dim CCtrl As ContentControl, Cancel As Boolean: Cancel = False
With ActiveDocument
  For Each CCtrl In .ContentControls
    If CCtrl.ShowingPlaceholderText = True Then Cancel = True: CCtrl.Range.Select: Exit For
  Next
  If Cancel = True Then
    MsgBox "Please complete all the items"
    .Saved = False
    SendKeys "{ESC}"
  End If
End With
End Sub

macropod · #3 04-16-2022, 07:31 AM

Cross-posted at: Macro for saving a macro enabled file to a non macro file
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

elaineAda · #4 04-17-2022, 01:58 AM

Ops i didnt know is the same forum.
Anyway thanks a lot, it helps

macropod · #5 04-17-2022, 05:37 AM

Quote:

Originally Posted by elaineAda

i didnt know is the same forum.

The whole point is that they are NOT the same forum...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Value of a Content Control based on the value of another content Control	jsc_msoffice	Word VBA	2	05-21-2021 09:51 PM
Content Control Dropdowns - How to duplicate the content control and allow a second choice	ashleyf	Word VBA	2	03-19-2020 09:11 AM
Content Control content deleted when re-uploading to SharePoint	Peterson	Word	5	06-27-2018 08:13 PM
Clicking the selected Content Control checkbox returns wrong control in vba event	DougsGraphics	Word VBA	2	06-24-2015 07:31 AM
Deleting a table from a content control -- preserving the content control	BrainSlugs83	Word Tables	8	11-14-2013 03:06 AM