Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2017, 10:30 PM
workingspade workingspade is offline Changing Drop Down List to Combo Box Windows 10 Changing Drop Down List to Combo Box Office 2016
Novice
Changing Drop Down List to Combo Box
 
Join Date: Oct 2017
Posts: 3
workingspade is on a distinguished road
Default Changing Drop Down List to Combo Box


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?
Reply With Quote
  #2  
Old 10-18-2017, 11:01 PM
macropod's Avatar
macropod macropod is offline Changing Drop Down List to Combo Box Windows 7 64bit Changing Drop Down List to Combo Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

What kind of dropdown?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-18-2017, 11:40 PM
workingspade workingspade is offline Changing Drop Down List to Combo Box Windows 10 Changing Drop Down List to Combo Box Office 2016
Novice
Changing Drop Down List to Combo Box
 
Join Date: Oct 2017
Posts: 3
workingspade is on a distinguished road
Default

I'm using drop down list content control and want to switch to combo box content control
Reply With Quote
  #4  
Old 10-18-2017, 11:43 PM
macropod's Avatar
macropod macropod is offline Changing Drop Down List to Combo Box Windows 7 64bit Changing Drop Down List to Combo Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-19-2017, 02:34 AM
workingspade workingspade is offline Changing Drop Down List to Combo Box Windows 10 Changing Drop Down List to Combo Box Office 2016
Novice
Changing Drop Down List to Combo Box
 
Join Date: Oct 2017
Posts: 3
workingspade is on a distinguished road
Default

Thanks! That works!
Reply With Quote
  #6  
Old 09-09-2022, 04:31 AM
smnel04 smnel04 is offline Changing Drop Down List to Combo Box Windows 11 Changing Drop Down List to Combo Box Office 2021
Novice
 
Join Date: Sep 2022
Posts: 1
smnel04 is on a distinguished road
Unhappy Microsoft 365 - Combo Box Conversion

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
Reply With Quote
  #7  
Old 09-09-2022, 06:12 AM
macropod's Avatar
macropod macropod is offline Changing Drop Down List to Combo Box Windows 10 Changing Drop Down List to Combo Box Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

If the code I posted isn't working for you, then your dropdowns aren't content controls.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Changing Drop Down List to Combo Box 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 PM.


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