title: Data Validation to Include Comma Character
body: <p>I am using the following short macro to assign Data Validation as a list of characters:</p>
  
  <pre><code>Sub DVList()
      With ActiveCell.Validation
          .Delete
          .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
          xlBetween, Formula1:="a,b,c,d"
          .IgnoreBlank = True
      End With
  End Sub
  </code></pre>
  
  <p>The macro works.</p>
  
  <p>I want to modify the macro to include the comma character in the list.  I don't see how to do this because the comma is the list separator.</p>
  
  <p>Am I stuck having to use worksheet cells to build the list??</p>