Multi-select picklist using Data Validation

I need to create a multi-value picklist in my spreadsheet. I read a previous post and copied/pasted the VB code into my spreadsheet, but I cannot get it to work. Thanks in advance for any assistance. Spreadsheet attached.

HI

Worked for me. What exactly are you doing?

rylo

Hi,

Found out it was working for me as well. Here's the hook...it only works on one column/spreadsheet. I have three picklist columns in my spreadsheet -- C, D, and E -- so when I was testing, I was clicking in column D which is the one I want to use a multi-select option in and it wouldn't work. I just happened to try column C and it worked! Lesson learned: if you have more than one picklist column, you can only make one multi-select and it has to be the first picklist column using Data Validation.

Thanks for responding.

Thanks so much!

Question...

How do I marked my posted "Solved"? I tried typing SOLVED as a reply and it told me my text was too short. Should I just edit the post and typed SOLVED?

Hi! I am trying to create a multi-select pick list and came across this post. I'm not exactly sure what to do with the macro posted above. Can someone explain. I am relativley new to creating lists!

I greatly appreciate any help you can provide!! Thank you!!

Right-click on the spreadsheet tab
Select View Code
Paste the VB code in the text box
SAVE and test

Got it!! Thank you prgates!!

Hello Qdogsmom, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and keep it in mind for future posts. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

I solved the data validation multiple select issue by creating a small form that I can use to display the values the users need to select.
This method presents other advantages, such as: you can use it on virtually any number of columns, you are able to control how it behaves, allowing you to set the selection as multiple or single, it can also be used to allow users to input free text, and it provides a way for the admin to pass some information, guidance, etc to the users. It also presents the advantage of not being overwritten by users when copy-paste occurs, a problem for the classic data validation feature in Excel.
data_validation_form.png
The example was created in Excel 2010 and I tested it on a 2003 version with the Office Compatibility add-in installed, without getting any errors.
Please find attached the example and detailed explanations of how to use it.
P.S.
I only posted this solution because the ones that I came across didn't solve the problem for more than one column and I thought it might help some people out.
DataValidationForm.xlsm
DataValidationForm_howto.docx