title: Click submit in userform to fill data in next row
body: <p>I created a userform.</p>
  <p>If I click submit I get next cell selected. When I run the userform again data are pasted into the same cells like before.</p>
  <p>This is VBA part of the &quot;submit&quot; command on the userform:</p>
  <pre><code>Private Sub CommandButton2_Click()
      Sheets(&quot;Test&quot;).Range(&quot;A2&quot;).value = TextBox3.value
      Sheets(&quot;Test&quot;).Range(&quot;B2&quot;).value = TextBox4.Text
      Sheets(&quot;Test&quot;).Range(&quot;C2&quot;).value = TextBox5.Text
      Sheets(&quot;Test&quot;).Range(&quot;D2&quot;).value = TextBox6.Text
      Sheets(&quot;Test&quot;).Range(&quot;E2&quot;).value = ComboBox1.Text
      
      Unload Me
  End Sub
  </code></pre>
  <p>I need when I press submit to go to next row and paste all data from userform.</p>