title: VBA Validation List : Choices are not displayed
body: <p>I am currently developping some Excel Macros, and I have to use the cell validation.</p>
  
  <p>I looked upon quite a lot of samples, which basically show  the same thing, but I can't get it to work properly.</p>
  
  <p>Here is my code :</p>
  
  <pre><code> Dim val As String: val = "this,is,sparta"
  
      With ActiveSheet.Range("C:C").Validation
          .Delete
          .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
          xlBetween, Formula1:=val
          .IgnoreBlank = True
          .InCellDropdown = True
          .InputTitle = ""
          .ErrorTitle = ""
          .InputMessage = ""
          .ErrorMessage = ""
          .ShowInput = True
          .ShowError = True
      End With
  </code></pre>
  
  <p>But in the end, instead of having three choices ("this", "is" and "sparta") in the dropdown list, I only have one, equals to "This,is,sparta".</p>
  
  <p>Did I miss anything in the configuration?</p>
  
  <p>Thanks in advance.</p>