title: Concatenate shows the second and third value except the first value
body: <p>I have this macro that concatenates values from 3 cells, the problem is that it only concatenates the 1st and 2nd values, before it only concatenated the the first value was 3, the second value was march and the third value was 2015, so the result just gives me " 3march"</p>
  
  <p>this is my code:</p>
  
  <pre><code>    Private Sub CommandButton1_Click()
  
      Sheets("Info").Activate
  
       Range("M2:Q2").Select
       Selection.Copy
       Range("A2").Cells(1).Select
  
       Do While ActiveCell.Value &lt;&gt; ""
        ActiveCell.Offset(1, 0).Select
      Loop
    Selection.Offset(0, 12).Select
      Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
         Selection.Offset(0, -12).Select
         Selection.Cells(1).Select
  
  
    'ahora viene la parte de pegar los valores,,,
    Selection.Cells(1).Value = TextBox1.Value
    Selection.Cells(1, 2).Value = ComboBox1.Value
    Selection.Cells(1, 3).Value = ComboBox4.Value
    Selection.Cells(1, 4).Value = ComboBox5.Value
    Selection.Cells(1, 5).Value = ComboBox6.Value
    Selection.Cells(1, 6).Value = ComboBox9.Value
     Selection.Cells(1, 7).Value = ComboBox13.Value
     Selection.Cells(1, 8).Value = TextBox3.Value
      Selection.Cells(1, 9).Value = TextBox4.Value
      Selection.Cells(1, 10).Value = TextBox8.Value
      Selection.Cells(1, 11).Value = TextBox6.Value
       Selection.Cells(1, 12).Value = ComboBox12.Value
  
       'HERE IS THE PROBLEM!!!!!!
        f_env = Selection.Cells(1, 3).Value &amp; "-" &amp; Selection.Cells(1,          4).Value &amp; "-" &amp; Selection.Cells(1, 5).Value
  
           Selection.Cells(1, 17).Value = f_env
  
  
  
       Unload UserForm1
       End Sub
  </code></pre>