#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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?
|
#4
|
||||
|
||||
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 |
#5
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down lists and pulling data from worksheet based on drop down selection | cjoyce73 | Excel | 5 | 07-17-2017 07:40 AM |
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 |