Data validation multi-select within a table

I have multiselect data validation applied to a table in Excel to limit what people can select from a dropdown list in a particular column. I am getting a data validation error when selecting multiple things from the dropdown list:

Screenshot 2022-06-29 151147.jpg

It then becomes difficult to correct and makes me delete everything out of the cell before the error goes away. The file is macros enabled. I have attached a sample workbook.

Is there something wrong in my VBA code, or is this just because I am trying to apply it to a table?

I should note that I can work around the errors, but multiple people edit the workbook, and I don't want to create confusion with having errors displayed. Thanks!

Hi,
Attched Sheet for your reference.(Sample(DV))
Try these following changes in your sheet.
1. Remove the Table and convert it to normal range in the Data Validation portion. Error will Disappear.
2.Change the A2 cell to Range upto which you need the Data validation. For ex:If Not Intersect(Target, Range("A2:A10")) Is Nothing Then
3.For the data validation to appear on numbers of cells, Highlight the cells and Create the data validation. For ex, Highlight Cell A2:A10, a pop up will appear asking for extended cells, click yes and create the DV.