title: Create A New Row and Select A Cell
body: <p>I am trying to give users the ability to add rows to a form, however I need them to do it programmatically so that the new row contains a checkbox with a macro already assigned to it.</p>
  
  <p>My solution has been to insert a row with an InputBox, which works great.</p>
  
  <pre><code>Dim rowloc As String
  
  rowloc = InputBox("Location to Insert Row", "What row do you want to insert 
  the new row ABOVE?")
  
  Rows(rowloc).Select
  Selection.Insert Shift:=xlDown
  </code></pre>
  
  <p>But I am having a heck of a time going to column B in that <i>new</i> row and inserting the checkbox. I don't have issues with making a new button in VBA, it's just getting to the other cell that's the issue.</p>
  
  <pre><code>Rows(rowloc).Offset(0, 1).Select
  </code></pre>
  
  <p>doesn't work either. Any helpful hints or solutions?</p>