Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2021, 02:32 PM
kevinbradley57 kevinbradley57 is offline I need three multiple-selection drop-down lists. Windows 7 64bit I need three multiple-selection drop-down lists. Office 2010 64bit
Advanced Beginner
I need three multiple-selection drop-down lists.
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default I need three multiple-selection drop-down lists.

I need to add three multiple-selection drop-down lists to a macro-enabled doc that my company is using as a boilerplate doc. My limited research tells me I need a user form. Do I need three different user forms, or one user form with three lists? Attached is a screenshot showing a mockup (the cell under Business Processes will be a free-form text field). The "ABC, Inc" is a permanent item. The drop-down list below it is for additional items.
Attached Images
File Type: jpg Dropdowns mockup.jpg (32.7 KB, 23 views)
Reply With Quote
  #2  
Old 12-01-2021, 02:51 PM
Guessed's Avatar
Guessed Guessed is offline I need three multiple-selection drop-down lists. Windows 10 I need three multiple-selection drop-down lists. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm not convinced you need a vba userform but if you do it that way it can be a single form with multiple lists on it.

You can just do the data entry in the Word document directly without using macros/userforms. Using Content Controls makes it pretty easy and you can enclose in a repeating content control if you want the user to make multiple selections from the same list.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-01-2021, 03:41 PM
kevinbradley57 kevinbradley57 is offline I need three multiple-selection drop-down lists. Windows 7 64bit I need three multiple-selection drop-down lists. Office 2010 64bit
Advanced Beginner
I need three multiple-selection drop-down lists.
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default

I have not found a way to use content controls to create multiple-selection drop-down lists. Can you point me to some resources, preferably with examples of whatever code is needed?
Reply With Quote
  #4  
Old 12-01-2021, 07:06 PM
Guessed's Avatar
Guessed Guessed is offline I need three multiple-selection drop-down lists. Windows 10 I need three multiple-selection drop-down lists. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You won't be able to do it with a single CC (like a vba userform listbox set to multi-select).
But you can either do a series of checkboxes or make it a dropdown CC inside a repeating CC.

See this to understand the concept - Word 2019 and 365 Tutorial Repeating Section Content Control Microsoft Training - YouTube. You can choose to include only one CC in the repeating CC.

I think this will be far simpler to set up and probably simpler for authors to use than going down the vba userform wormhole. If you are using a vba userform already for other things then it might make more sense to continue that way so the users don't have to mix and match their input methods.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 12-02-2021, 01:07 AM
gmayor's Avatar
gmayor gmayor is offline I need three multiple-selection drop-down lists. Windows 10 I need three multiple-selection drop-down lists. Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you are going to employ a userform, I strongly suggest that you save the document as a template and create new documents from it. You can certainly do this with a single userform and (probably) three combo-boxes and a text boxand I would combine it with content controls on the document to receive the selected data. See Create a userform for the basics.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need three multiple-selection drop-down lists. Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
I need three multiple-selection drop-down lists. Drop-down menu in Excel, filling up the lists according to selection blackarrow Excel 18 01-18-2017 08:04 AM
Link multiple cells in drop-down lists Trial4life Excel 0 09-08-2014 05:08 AM
Multiple Drop Down Lists in word ali212006 Word 3 03-13-2013 12:16 PM
Ho to perform multi selection in drop down lists? nashville Word 0 09-29-2010 07:10 AM

Other Forums: Access Forums

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


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