title: Comma Separator: Ignore the comma within the data using excel macro
body: <p>I'm new in using of excel macro vba and I have a problem with listing the data in dropdown. I want to create a dropdown and has a comma in one line of record, but my code separates it. Here's my code.</p>
  
  <p>Code:</p>
  
  <pre><code>Dim ShipAddress As String
  Dim MyList5() As String
  ReDim MyList5(ShipAddressCount)
  
  For h = 1 To ShipAddressCount
      ShipAddress = rsShipAddress!ShippingAddress
      MyList5(h) = ShipAddress
      rsShipAddress.MoveNext
  Next
  
  
   With Range("E4:E" + cnt).Validation
  .Delete
  .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
  Operator:=xlBetween, Formula1:=Join(MyList5, ",")
  .IgnoreBlank = True
  .InCellDropdown = True
  .InputTitle = ""
  .ErrorTitle = ""
  .InputMessage = ""
  .ErrorMessage = ""
  .ShowInput = True
  .ShowError = True
  End With
  </code></pre>
  
  <p>When the list has a dropdown record of "name,name" it would count as two lines. I want to have a record in list that has a comma in one line. Do you all have other way to resolve this?</p>
  
  <p>Any help will be appreciated. Thank you.</p>