|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Having trouble creating a multiple selection drop down list, even after checking other threads
Hi there! I'm trying to create a multiple selection drop down list. Here is where I'm at:
1. I opened the developer tab, turned on design mode, and selected "List Box" from the ActiveX Controls. 2. Opened properties and changed the MultiSelect behavior to "2 - fmMultiSelectExtended" 3. Double clicked my list box to open the code 4. And now I'm stuck. I've tried copying codes others have used and just changing the name of the option I'm trying to add but that didn't do anything. I need people to be able to select more than 1 option from the list. Can anyone guide me step for step on what to do? I'm presenting this new form to the company on Friday but can't figure this part out at all. |
#2
|
|||
|
|||
Sub PopBox()
With ListBox1 .Clear .MultiSelect = fmMultiSelectMulti .AddItem "A" .AddItem "B" .AddItem "C" End With End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple-selection drop-down in Word | R3d3mpt10n | Word VBA | 3 | 12-11-2019 03:00 PM |
Autofill a field based on drop down list selection | lascough20 | Word | 2 | 09-21-2018 02:24 AM |
Creating text based on drop-down menu selection | emckillen | Word | 9 | 09-27-2017 04:52 PM |
Change cell color when selection is made from a drop down list | fedcco | Excel | 12 | 08-28-2012 10:43 PM |
Trouble with drop down list | yessmarie | Word VBA | 1 | 05-25-2012 12:43 PM |