Excel Drop Down Multiple Select/Remove & Auto Alphabetize Selections

[Sactown Steve]

Hi there. I'm brand new to Excel data validation and VB coding. I'm really excited to learn about what Excel can really do. I watched several very helpful videos and figured out most of what I'm trying to achieve. I'm stuck on how to:

1. How to auto-sort selections as shown in the Target columns (alphabetically sorted in Target columns). When I select from the alphabetized list, the value displayed in the drop down mimics the order I selected them (so not alphabetized in some cases). Example: If Target values are Bob, Chris, James... and I select from the drop down Chris, Bob, James, the drop down displays names in the order I selected. I would like the displayed names to be alphabetized.

1. How to code deselecting a value by clicking on it in the drop down. I would like to be able to select a name that has already been selected, and upon clicking that name, remove it from being displayed. Example: I selected Bob, Chris, James.... I need to remove Chris, so I click the drop box and select Chris. The "double selection" of Chris removes him from being displayed (he's deselected).

I uploaded a screenshot of the VB coding I'm using. Target values are in multiple columns [thus Range("Q:U")]. I also coded it to display each selected value (multiple values displayed in a cell) to not repeat a value if it has already been selected. So clicking on the same name does not add it again to be displayed. I'm on the right path, but really could use help figuring out the two above issues.

THANK YOU!