Forum Discussion
AdrianP2022
May 04, 2022Copper Contributor
Drop down lists - multiple values
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
- mtarlerSilver ContributorThat 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