Hello, I am trying to create a column where there is a drop down list in each cell and have the ability to select multiple options.
I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA code.
However - this excel doc needs to live online (on sharepoint/onedrive) where the VBA becomes irrelevant.
Is there a way to set this up where it will work living online?
Thanks!
VBA works in all the paid versions of 365 (or so it is claimed) so you may need to upgrade.
Bernie Deitrick
Excel MVP 2000-2010
A thought which might work, hard to tell without seeing your data, but would utilizing a pivot table and SLICERS be beneficial for you?
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Hi,
I need a similar thing for Excel for WEB - but no slicer tricks - the list has to be accessible from a cell in a standard table.
Are multi select drop down lists at all possible to implelent in Office Script (as of May 2023) ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks