Need help! Ability to chose multiple items from a dropdown

Microsoft Office 2010 professional
June 13, 2016 at 12:49:54
Specs: Windows 64
I am need of help desperately!

I've created a drop-down list on its own tab which I've named 'global'. On my main spreadsheet columns Q2:O1500, U2:U1500 and Y2:Y1500 (all are using the same pick-list info) I'd like for the end user to have the ability to pick multiple items on the pick-list? I know this is possible but all the websites (about 15+) and 3 hours later I am still at square one. Can someone assist me, please?

I will appreciate any assistance I can get.


See More: Need help! Ability to chose multiple items from a dropdown

Report •

#1
June 13, 2016 at 14:26:29

Report •

#2
June 13, 2016 at 20:16:37
Thank you! Worked like a charm with the exception of the fact that the code changed all my dropdown list however I only needed this code to impact columns Q,U & Y. Also I noticed there is a different code for passwork protected worksheets (which this is) - can you help me with a code?

Report •
Related Solutions


Ask Question