Drop down lists - multiple values

%3CLINGO-SUB%20id%3D%22lingo-sub-3302370%22%20slang%3D%22en-US%22%3EDrop%20down%20lists%20-%20multiple%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3EI'd%20like%20to%20include%20a%20drop%20down%20list%20in%20an%20excel%20column%20hosted%20on%20Sharepoint%2C%20but%20where%20multiple%20values%20can%20be%20selected%20in%20the%20same%20cell%20(and%20where%20one%20selection%20doesn't%20over-write%20the%20previous%20selection).%26nbsp%3B%20I%20created%20a%20macro%20to%20enable%20this%20but%20when%20uploaded%20to%20Sharepoint%20it%20wouldn't%20work.%26nbsp%3B%20Google%20tells%20me%20that%20Sharepoint%20won't%20accept%20macros.%26nbsp%3B%20Anyone%20know%20of%20a%20simple%20way%20round%20this%3F%26nbsp%3B%20Thanks%2C%20Adrian%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3302370%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302461%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20lists%20-%20multiple%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302461%22%20slang%3D%22en-US%22%3EThat%20is%20correct%20that%20macros%2FVBA%20doesn't%20work%20in%20the%20online%20Excel.%20There%20are%20scripts%20you%20can%20look%20into%20using.%20Also%2C%20maybe%20you%20could%20do%20the%20drop%20down%20list(s)%20differently%20but%20I'm%20not%20sure%20I%20understand%20what%20you%20are%20trying%20to%20do%20to%20make%20suggestions%20on%20that%20side%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone

I'd like to include a drop down list in an excel column hosted on Sharepoint, but where multiple values can be selected in the same cell (and where one selection doesn't over-write the previous selection).  I created a macro to enable this but when uploaded to Sharepoint it wouldn't work.  Google tells me that Sharepoint won't accept macros.  Anyone know of a simple way round this?  Thanks, Adrian

 

1 Reply
That is correct that macros/VBA doesn't work in the online Excel. There are scripts you can look into using. Also, maybe you could do the drop down list(s) differently but I'm not sure I understand what you are trying to do to make suggestions on that side