Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2022, 05:29 AM
macropod's Avatar
macropod macropod is offline Macro to help turn text in square brackets into dropdown content controls Windows 10 Macro to help turn text in square brackets into dropdown content controls Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For example, assuming you first select all the options:


Code:
Sub AddComboBox()
Application.ScreenUpdating = False
Dim objCC As ContentControl, StrTxt As String, i As Long
With Selection.Range
  If InStr(.Text, "[") = 0 Then Exit Sub
  If InStr(.Text, "]") = 0 Then Exit Sub
  If .Characters.Last <> "]" Then .MoveEndUntil "]", wdBackward
  StrTxt = .Text
  StrTxt = Replace(StrTxt, "]", "")
  .Text = vbNullString
  Set objCC = .ContentControls.Add(wdContentControlComboBox)
  With objCC
    .SetPlaceholderText Text:="Please make a selection"
    For i = 1 To UBound(Split(StrTxt, "["))
      .DropdownListEntries.Add Split(StrTxt, "[")(i)
    Next
  End With
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-16-2022, 06:24 AM
jmf_techs jmf_techs is offline Macro to help turn text in square brackets into dropdown content controls Windows 10 Macro to help turn text in square brackets into dropdown content controls Office 2021
Novice
Macro to help turn text in square brackets into dropdown content controls
 
Join Date: Oct 2022
Posts: 2
jmf_techs is on a distinguished road
Default

Thank you! It worked! Amazing!
Reply With Quote
Reply

Tags
content control, microsoft word, vba content control

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to help turn text in square brackets into dropdown content controls Content Controls - Dependent Dropdown someazguy Word VBA 14 02-05-2023 08:01 PM
Clear all content controls (Text, dropdown) AND change option button values to FALSE in MS Word Form Janet D Word VBA 7 01-14-2023 02:36 AM
Macro to help turn text in square brackets into dropdown content controls Content Controls - Dependent Dropdown & Text Mightymegs Word VBA 6 05-18-2020 05:34 AM
Macro to help turn text in square brackets into dropdown content controls Add a return between two square brackets jeffreybrown Word VBA 15 02-20-2017 05:35 PM
Macro to save docx to doc that checks compatibility and converts content controls to static content. staicumihai Word VBA 4 10-12-2016 08:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft