title: Excel Data entry forms in VBA
body: <p>I am very new to VBA and have been searching to try to figure this out but with no luck.</p>
  
  <p>I am trying to make a form that pops up and has a bunch of different fields to enter and then when the form is submitted, the information is input into separate, specific cells. Also, once the information is input into the cells, it needs to be printed for our records. One last thing to add is that I need some of the fields to disappear if they are empty on the form so that they do not print.</p>
  
  <p>I have a lot of fields for this and all that I have found is how to insert into a new row. If this can be done it would help me out a LOT. If anyone can point me in the right direction then I may be able to figure some out on my own I am fairly literate in HTML so I am able to do some coding.</p>
  
  <p>The fields I have to enter:</p>
  
  <pre><code>Deposited By:
  Number of Deposits:
  Total Checks:
  Electronic Deposit Number:
  Electronic Deposit Number:
  Manual Deposit Number:
  Deposit Amount:
  Deposit Amount:
  Deposit Amount:
  Houston Depos:
  Dallas Depos:
  Austin Depos:
  Houston Video:
  Dallas Video:
  Austin Video:
  Houston Records:
  </code></pre>
  
  <p>I will also need to add a button or make the form popup whenever the spreadsheet is opened so that the information can be entered but I believe that may be a little easier to figure out. Along with pre-filling the form with the information already on the page so that it can be edited.</p>