Target.column for Data Validation would like to target some cells within column

[iggypop]

Hello All, hopefully you can help, I have visited many forums and found the below code that works, but I have tried tweaking for my specific needs and I am unable to:

Basically it is allowing me to use any data validation cells in column 2 as multi select cells with comma separation (i.e. select1, select2, select3) , problem is that I have a few data validation cells in column 2 that I only want as a single select.

Please Login or Register  to view this content.

[Mumps1]

See if this helps. Please read the comments in the code:

Please Login or Register  to view this content.

[iggypop]

Thank you, Mumps1, much appreciated, sorry I am new to VBA coding so the code I provide basically just needed me to correct the sheet names(s) and Column/Row numbers, so I will take a look at your proposed code and try to figure where to insert the code from my VBA script, will let you know if I am able to figure it out.