title: Convert variant array values to strings in vba
body: <p>I have a sub that takes a variant array generated in a userform and I would like to extract all of the values and return them as a single comma delimited string.  This is probably pretty basic, but I'm having trouble getting the values from the array into a string.  I'm getting a type mismatch when I try to cast the variant as a string.  Any idea what I'm doing wrong?</p>
  
  <pre><code>Sub formSearch(ParamArray search() As Variant)
      Dim returnString As String
      returnString = ""
      For i = LBound(search) To UBound(search)
          returnString = returnString + CStr(search(i)) + ","
      Next
      MsgBox returnString
  End Sub
  </code></pre>