SOLVED

Is it possible to create a drop-down list which you can select multiple choices

%3CLINGO-SUB%20id%3D%22lingo-sub-1230271%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20create%20a%20drop-down%20list%20which%20you%20can%20select%20multiple%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230271%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20any%20help%20on%20how%20to%20create%20a%20drop-down%20list%20where%20you%20could%20select%20multiple%20elements%20of%20that%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%20of%20possible%20values%3C%2FP%3E%3CP%3EA1%3C%2FP%3E%3CP%3EA2%3C%2FP%3E%3CP%3EA3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20the%20multiple-choice%20list%2C%20the%20cell%20would%20show%20the%20selected%20values%3A%3C%2FP%3E%3CP%3EA2%3C%2FP%3E%3CP%3EA3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20any%20of%20your%20suggestions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndrea%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1230271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1230297%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20create%20a%20drop-down%20list%20which%20you%20can%20select%20multiple%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F582910%22%20target%3D%22_blank%22%3E%40ChocolatePartyExpress%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20VBA%20coding.%20See%2C%20for%20example%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fselect-multiple-items-drop-down-list-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fselect-multiple-items-drop-down-list-excel%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1230309%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20create%20a%20drop-down%20list%20which%20you%20can%20select%20multiple%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230309%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%20for%20your%20quick%20reply.%20I%20will%20have%20a%20go%20at%20this%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndrea%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1230330%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20create%20a%20drop-down%20list%20which%20you%20can%20select%20multiple%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F582910%22%20target%3D%22_blank%22%3E%40ChocolatePartyExpress%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAndrea%2C%20you%20are%20welcome.%20There%20are%20a%20lot%20of%20other%20posts%20with%20similar%20solutions%2C%20just%20google%20for%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I would like any help on how to create a drop-down list where you could select multiple elements of that list?

 

example:

 

List of possible values

A1

A2

A3

 

After the multiple-choice list, the cell would show the selected values:

A2

A3

 

Many thanks for any of your suggestions

 

Kind regards

 

Andrea

 

 

 

4 Replies
best response confirmed by ChocolatePartyExpress (New Contributor)

Many thanks for your quick reply. I will have a go at this now.

 

Kind regards

 

Andrea

@ChocolatePartyExpress 

Andrea, you are welcome. There are a lot of other posts with similar solutions, just google for them.

@Sergei Baklan I have tried using this code and it doesn't seem to work. Have checked that the cell is changed to the one I need, have tried within a module and without.

 

I think I'm following all the steps. I notice in one of them (Step 3) it says to double click and paste into a module, but the pic shows him double clicking on sheet name and also typing "Option Explicit."

 

I'm trying to work out if my issue is something more foundational, this is a hand me down spreadsheet I'm trying to clean up, so not sure which sheet is actually Sheet 1 for instance.  

 

Can anyone think of something obvious I've missed. (it is an .xlsm file.)