Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
68
Views
Topic starter
Hi there,
I tried adding your code to my spreadsheet and it doesn't seem to be working. Any idea what I have done wrong? master drop down list on the page marked 'master' column F3 as per your spreadsheet.
Many thanks,
Mikaela
Posted : 02/09/2020 8:29 am
Hi Mikaela,
I'm afraid there's no attachment. Did you click on the Upload button?
Regards
Phil
Posted : 02/09/2020 8:51 am
Topic starter
HI Phillip,
Sorry see attached.
Mikaela
Posted : 03/09/2020 4:06 pm
Hi Mikaela,
There's no code in the workbook you supplied? I've taken the code from this post
https://www.myonlinetraininghub.com/select-multiple-items-from-drop-down-data-validation-list
and put it in your workbook, in the Sheet1 code module, and created a named range called DV_Range that references F2:F500.
I think it works as you want now, please see attached file.
Regards
Phil
Posted : 04/09/2020 6:03 am
