Changing Drop Down to Allow Multiple Responses and adding new responses to drop down

I have this code (courtesy of contexture.com) that allows me to put in a drop down which allows the user to add new items to the drop down. If they add an item, the new list is sorted. The only problem is, I want to allow the user to pick multiple responses and have them populate in the same cell, separated by column.

Example:

My dropdown consists of types of dogs, and currently has three types listed: Boxer, Poodle, Pug...

My user has a Boxer and a Collie. I want them to be able to enter Boxer from the dropdown, but also allow them to type in Collie... and then Collie should be added to the master list so the next person could pick it if they want. The code I have works great as long as you have one dog...

I would prefer to have multiple dogs listed in the same field (since I never know how many dogs someone will have, I don't know how many columns to have for 1st dog, 2nd dog, etc.) NOTE: this is my example... surely no one would have over 4-5 dogs, so columns would work... but in my real life application, you could have multiple choices and never know how many (granted, there shouldn't be but 4/5 at max, but would still prefer all to be in same column)

This is the code I currently have... First is the data entry that allows a choice and allows a new entry... second is the code that accepts a new entry, updates my list, and sorts for the next person.

I can find code to allow you to enter multiple answers, but don't know how to integrate the two. Can anyone help me?

Thanks much!


THIS IS THE DATA ENTRY CODE:

Please Login or Register  to view this content.

Hello Anthony Buchanan,

Welcome to the Forum!

If you can post a copy of your workbook, please do so. It will make answering your question faster and more accurate.