Changing Drop Down List to Combo Box

workingspade · #1 10-18-2017, 10:30 PM

I have a bunch of drop down lists, but I just realized that I actually need a combo box, where the user can manually enter a different response. Is there a simple way to migrate my all the display names and values from the drop down list to the combo box?

macropod · #2 10-18-2017, 11:01 PM

What kind of dropdown?

workingspade · #3 10-18-2017, 11:40 PM

I'm using drop down list content control and want to switch to combo box content control

macropod · #4 10-18-2017, 11:43 PM

Try:

Code:

Sub Demo()
Dim CCtrl As ContentControl
For Each CCtrl In ActiveDocument.ContentControls
  With CCtrl
    If .Type = wdContentControlDropdownList Then .Type = wdContentControlComboBox
  End With
Next
End Sub

workingspade · #5 10-19-2017, 02:34 AM

Thanks! That works!

smnel04 · #6 09-09-2022, 04:31 AM

Can you please 'dumb this down' for me? I have multiple drop downs in my document, tried the below code in the visual basic block but it does not seem to work

macropod · #7 09-09-2022, 06:12 AM

If the code I posted isn't working for you, then your dropdowns aren't content controls.

Rafi · #8 06-13-2024, 01:17 AM

Quote:

Originally Posted by macropod

Try:

Code:

Sub Demo()
Dim CCtrl As ContentControl
For Each CCtrl In ActiveDocument.ContentControls
  With CCtrl
    If .Type = wdContentControlDropdownList Then .Type = wdContentControlComboBox
  End With
Next
End Sub

Windows 10 Office 365.
The code works great!!
Thank you very much, you saved me days of work!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pasting a table with combo boxes to a new document looses the combo box	bobsut@enviro-consult.com	Word	1	01-03-2017 01:29 PM
Word 2010 Content Control help - Combo Boxes vs Drop Down List	proghy	Word	1	09-16-2014 02:01 PM
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM
Format Font Size in Combo Box List	lukewarmbeer	Word VBA	0	08-27-2011 07:28 AM
Bold list items in a combo box	DrewB	Word VBA	0	07-17-2009 11:32 AM