Hello, all. I have a worksheet that I would like to allow people to add an additional value to a cell in a certain column without losing the old value. Ideally the new value would be separated from the old value with a comma. I know you can manually do this by just adding additional text in the edit window but I'd prefer to not rely on that. If there's a chance to make a mistake it'll likely happen more than I like.
So, if a cell already has, say, "Colorado" in it and someone clicked on the cell and typed "Wyoming", the new cell value would be "Colorado, Wyoming". The if someone else came along, clicked on the cell and entered "New York" in the cell, it new value would read "Colorado, Wyoming, New York".
My original thought was that if I used a Worksheet_Change sub (example below) as a trigger to adding the new value to the old value I have the beginnings of a mechanism.
Please Login or Register to view this content.
Only problem is now I have no idea how to retain the old value and add in the new.
Any hints? Thanks in advance.
Bookmarks