Multi select dropdown lists in excel ONLINE

joeVBAhelp!
NewLounger
Posts: 11
Joined: 23 Aug 2016, 02:29

Multi select dropdown lists in excel ONLINE

Post by joeVBAhelp! »

Just as the title says. is this possible? It has to be excel ONLINE, I have already solved on desktop through VBA but this obviously doesn't convert to online

I had a quick look at office scripts but I believe these need to be triggered (cannot run on change/ on edit as VBA or google appscripts can)

I think it just cannot be done but if anyone has a solution I would be very grateful.

Thanks
Joe

ps - This question is posted on another forum which I wouldn't normally do. I haven't had any response and I don't think it's possible so hope it's ok to post here too

https://www.excelforum.com/editpost.php ... &p=5522140
Last edited by joeVBAhelp! on 28 May 2021, 07:22, edited 1 time in total.

User avatar
HansV
Administrator
Posts: 78390
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multi select dropdown lists in excel ONLINE

Post by HansV »

As far as I know that isn't possible.

P.S. If you post the same question on multiple forums (called cross-posting), it is polite to post a link on each of those forums to the other one(s). That way, others can check whether it has been solved elsewhere. Some forums will ban you if you don't do that.
Best wishes,
Hans

joeVBAhelp!
NewLounger
Posts: 11
Joined: 23 Aug 2016, 02:29

Re: Multi select dropdown lists in excel ONLINE

Post by joeVBAhelp! »

HansV wrote:
28 May 2021, 06:41
As far as I know that isn't possible.

P.S. If you post the same question on multiple forums (called cross-posting), it is polite to post a link on each of those forums to the other one(s). That way, others can check whether it has been solved elsewhere. Some forums will ban you if you don't do that.

Thanks Hans.

I will add the link to the other post here too

User avatar
HansV
Administrator
Posts: 78390
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multi select dropdown lists in excel ONLINE

Post by HansV »

Thank you! :thumbup:
Best wishes,
Hans

User avatar
Doc.AElstein
BronzeLounger
Posts: 1499
Joined: 28 Feb 2015, 13:11
Location: Hof, Bayern, Germany

Re: Multi select dropdown lists in excel ONLINE

Post by Doc.AElstein »

That link may not be accesible to everyone,
maybe this one ...
https://www.excelforum.com/excel-genera ... nline.html
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also