Drop down lists - multiple values

[AdrianP2022]

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

[#2]

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