Forum Discussion

AdrianP2022's avatar
AdrianP2022
Copper Contributor
May 04, 2022

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

  • mtarler's avatar
    mtarler
    Silver Contributor
    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

Resources