VBA code - Multi-Select drop downs- some cols duplicate items Ok, some cols duplicate items NOT ok

Question

Hello,

I have a data sheet with sample data in range A7:X600 (replacing my real data).

(Please see picture and file link below). The picture and file give you an idea of what I need. I have another sheet in this file that contains the source for data validation list drop downs. I know how to do the single select picks with standard data validation list in columns A,H,R,S,V

I need 3 things:

1. A VBA procedure for the data sheet for columns I,J,K,P to allow multiple selection picks and allow duplicate items within those cells in those columns.
2. A VBA procedure for the data sheet for columns L,M,U to allow multiple selection picks but NOT allow duplicate items within those cells in those columns.

The data range may grow beyond row 600. Such as A7:X1000.

3. After the data is picked for multiple selection drop down columns I,J,K,P, L,M,U, I need an easy way to edit those cells without clearing the whole cell contents then have to enter the multiple picks all over again.

Can you please assist by providing the 2 VBA code procedures and advice on how to easily edit the multiple selection pick cells after the data is picked? Thank you very much!

Here is a picture of the data sheet

Here is a link to my One Drive of the sample file

https://1drv.ms/x/s!AvGvMjf2TNATib03docsWxmSs9yIaw?e=47H9fc

Thank you very much!!

Craig

Answer 1

You'll find everything you need on Excel Data Validation - Select Multiple Items

You can download a sample workbook from that page with working examples of the various types of data validation that you describe.

Answer 2

thank you very much!!