title: VBA Entering userform data at next blank row correctly
body: <ol>
  <li>Created a userform</li>
  <li>Added a textBox and a comboBox</li>
  <li>Added a submit button</li>
  <li>When submit is clicked it adds the data to a spreadsheet</li>
  </ol>
  
  <p>From what I have been told and what I have read this is wrong</p>
  
  <pre><code>ActiveCell.Value = TextBox3.Text 
  ActiveCell.Offset(0, 1).Select   
  ActiveCell.Value = ComboBox1.Text  
  ActiveCell.Offset(1, -1).Select  
  </code></pre>
  
  <p>This works but <a href="https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros">I've been told I shouldn't use the .select keyword when possible</a>. I've read that to make my code reusable I should create variables. How would a professional developer write this code, can it be written in less lines and how can I refer to the activecell offset without using select?</p>