I need to add a data validation list to Cell whose few values contains comma.
I have the same problem like this [Data Validation to Include Comma Character](https://stackoverflow.com/questions/18722398/data-validation-to-include-comma-character)

But I can't reference a range, because I am creating a new workbook and feed its cell with the data validation list. So reference is not working for me and since some values contain comma so I can't set the **Range** into **String** and use that after **Formula1**

```
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:=myStr

```

Another idea I found that I can replace comma with other character(dummy character) and after populating the cell replace that dummy character with comma but problem is that **how to replace that dummy character with comma ?**

Another way is that override the Formula1 so that I can use dummy character as delimiter but I don't know how to achieve this.

Please suggest any solution, my final goal is to create a new workbook and populate it with data validation list through **Excel VBA**