Best way to combine to worksheet change events

I have 2 worksheet change events that happen on my worksheet.
One first - looks for duplicate choices and prevent the user form using them in column B
Second one - allows the user to combine multiple choices from a data list and separate them by "/"

The two code are separated by '********************* for your to distinguish them apart

Earlier they were both working but now when I choose the drop down and then go to add another multiple choice it does not combine the two it just has either one or the other. How to best get them working together.


The reason why I want to add this is I have 37 Different Independent choices in one Drop down and you could have any combination of 2,3,4,5 services running at any given time. There is no way to account for all the different combinations to have that be an choice already. I saw using Multiple choice with data validation but it did not show how to get 2 change events working together.

Any help would be great.

Please Login or Register  to view this content.