title: How to export values from UserForm to new Excel-sheet?
body: <p>I have a UserForm from which I wan't to copy Three different values and put them in my new sheet together with an explanation in front of each value, but it isn't working, could somebody help me understand why?</p>
  
  <pre><code>Private Sub cmbExport_Click()
  
  Sheets.Add(After:=Sheets(Sheets.Count)).Name = "Export"
  
  Export.Range("A1").Value = "Riskpremie"
  Export.Range("A2").Value = "Teknisk premie"
  Export.Range("A3").Value = "Slutpremie"
  
  Export.Range("B1").Value = TxtRiskpremie.Value
  Export.Range("B2").Value = TxtTeknpremie.Value
  Export.Range("B3").Value = txtSlutpremie.Value
  
  End Sub
  </code></pre>
  
  <p>Thank you in advance!</p>