Multiple Data Validation entries into one cell

Is it possible to create a formula using a Data Validation List where it will add a new entry to the existing entries in a cell?
For example: I have a data validation list with the names of Pete, Chris, Bruce, Carly, Megan, and Becky. With the normal data validation set I can select one entry and it will be output into the designated cell. If I select Bruce then Bruce with be placed in the cell. Is it possible to set it up so that each time I click on data validation it will add an entry to the already existing entry? E.g. I have already selected Bruce then I decide to add Becky, I want the output cell to show both Bruce and Becky.

I know I can do this with a formula that will place all the results from different cells into a single cell, but I would then have to create multiple data validation entries of which I would rather avoid if possible. Not to mention I don't remember how to do this formula anyway......

Bruce

Originally Posted by FDibbins

The whole point of DV is to have a specified list and to stick WITH that list - and to make sure that users ONLY use items in that list. From the sounds of it, what you want to do, you might just as well not even use DV. What would the difference be in having Peter already in the list and then someone mis-typed Petre - compared to you wanting to add a new name Petre?

Exactly! I want whomever is using this spreadsheet to stick with the specified list in the spreadsheet to make sure they only use the items/names in that list.
I use Data Validation: List, which creates a drop down list of the possible entries that have already been typed in. So there is no typing is needed as it is all selected from the drop down list. You can of course start typing and the list will auto fill for you as needed. If there is another way to do this, then how? I was directed to data validation when I was looking for drop down lists. If I can figure this out it will be used for more than just names, one of the lists has over 250 entries.

Bruce

Ummm, it's in my first post.
Here it is again: Is it possible to create a formula using a Data Validation List where it will add a new entry to the existing entries in a cell?
For example: I have a data validation list with the names of Pete, Chris, Bruce, Carly, Megan, and Becky. With the normal data validation set I can select one entry and it will be output into the designated cell. If I select Bruce then Bruce with be placed in the cell. Is it possible to set it up so that each time I click on data validation it will add an entry to the already existing entry? E.g. I have already selected Bruce then I decide to add Becky, I want the output cell to show both Bruce and Becky.
Basically I want to have it set up so each time I click on a name or item in the Data Validation List, it will add what I click on to what is already in the existing cell.

Bruce

Cool thanks, I will work on this as soon as I can. I will let you know how it works out.

Bruce

One more question before I retire for the night. How do I use this same code for different lists? I know I need to change the reference cells of the VBL code, but how do I use this same code more than once on the same sheet? Would I just add the other ranges to the code as is like this:

Please Login or Register  to view this content.

?

Bruce

It seems to be working so far except for 2 problems.
1. When I start adding values to a cell the macro puts a "0," as the first entry.
2. This is more of a slight annoyance and can possibly live with; I have to clear the entire cell contents and start over if I need to change one value, as it will not let me delete only one value.
Thanks for the great help!
Bruce

Is there any way of removing the "0," that shows up when I start adding values to the cell with your macro tied to it?
Bruce

More problems with that macro I recently noticed, and it goes all the way back to the last one before the multiple values one (I didn't check the previous ones).
The problems:
1. I still have to close the spreadsheet and re-open it to clear out the old values that I don't want.
2. If I close the sheet when I am finished with it and re-open it later and then try and add in new values into the data validation cells it will clear the list completely so I have to enter in all the values again.

Questions:
A. Is there a way to program the VBA code to not delete the values unless I manually delete them, and to keep adding values when I add new ones without deleting the old ones?

B. Is it possible to program the VBA code to delete a value I choose if the value is already in the Data Validation cell? I.e. if "Marcus" is already in the DV cell and I pick "Marcus" again in the dropdown list it will delete "Marcus" from the list entirely until I choose to add "Marcus" again.

Bruce