More than one Multi-select DropDown on a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2970133%22%20slang%3D%22en-US%22%3EMore%20than%20one%20Multi-select%20DropDown%20on%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970133%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20use%20VBA%20to%20create%20more%20than%20one%20multi-select%20dropdown%20on%20a%20single%20worsksheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2970133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970234%22%20slang%3D%22en-US%22%3ERe%3A%20More%20than%20one%20Multi-select%20DropDown%20on%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220202%22%20target%3D%22_blank%22%3E%40chrisjep65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%20-%20see%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fexcel-data-validation-multiple.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20Data%20Validation%20-%20Select%20Multiple%20Items%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970294%22%20slang%3D%22en-US%22%3ERe%3A%20More%20than%20one%20Multi-select%20DropDown%20on%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220202%22%20target%3D%22_blank%22%3E%40chrisjep65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EMaybe%20this%20example%20file%20will%20help%20you%20further.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there a way to use VBA to create more than one multi-select dropdown on a single worsksheet?

4 Replies

@chrisjep65 

Maybe this example file will help you further.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

thank you! i got it!
Thank you! much appreciated