title: VBA textbox to cell
body: <p>I have a input user form in excel where a user enters data into a three different textbox. This is my code</p>
  
  <pre><code>      Private Sub Process_Click()
  
       Worksheets("1").Range("A1").Value = Date.Value
       Worksheets("1").Range("B1").Value = Name.Value
       Worksheets("1").Range("C1").Value = Amount.Value
  
  
       End Sub
  </code></pre>
  
  <p>So the first time I press process it will write the data into those cells A1,b1, and C1. What i want to do is that everytime I open the form and click process on my form I would like for those values to go down a row for example the next time i click process it will go to A2,b2,and c2, and so on. </p>