EXCEL VBA - Multi Selection DATA VALIDATION

Hi Expert,

I have a multiselection data validation in particular Cell. ex: in cell A1

drop down list contains - A, B, C, D

with multiselection the cell value shows - A; B; C; D;

I want to restrict user from entering any value which is not available in the list - ex: E;

REQUIREMENT:
user can copy paste A; B; C; D; OR B; C; D; from any other cell to A1 but if it contains like E; which is not in the drop down list, it should show message ex - A; B; E;.

Thanks
MG

Its a huge file hence cannot share.
Also the records in the cell i.e. A; B; C; are inserted with some lengthy process with multiple codes (not specific).

Request you to treat the given example above as a input.

Please help me with this.

HOW IT SHOULD WORK?
it should split each records from the cell separately i.e. A; B; C; should be treated separately and then we should check whether "A" is from the list OR "B" is from the list or "C" is from the list.

if there are any other Characters such as "E" it should show message and undo the copy paste.

Thanks
MG

-----

still waiting for help

-----

Here is a single selection, you need to changes by yourself.

Please Login or Register  to view this content.

Hi Expert,

Please find attached file with all the required details.

Expecting early reply as this might be the easy things for experts.

Same details are below for quick view:

Attachment 551991

Thanks
MG

''

waiting for help !!!

''

try:

Please Login or Register  to view this content.

Thanks for the reply
Sorry But How To Use

Please Login or Register  to view this content.

I have values apart from dates . that was just an example. but it seems that you have treated the code only for months column.

i have other records also like country name, employee name, etc.