title: Move Combobox onclick of a button to a next row excel VBA
body: <p>I have created a vba code to create combobox and populated with my named range. Now i want to make when i select something from a combobox it has to set that value in that current cell and it should move to next row so that i can keep setting a value in each cell from a combobox.</p>
  
  <p>i have this following code to create combobox , but i dont know how to make it move to a next row with .onaction </p>
  
  <pre><code>Sub AddComboBoxes()
  Dim cb As Object
  Dim aCell As Range, r As Long
  
  
  For i = 1 To 1
      Set aCell = Sheet1.Cells(i, 5)
      Set cb = Sheet1.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Left:=aCell.Left, Top:=aCell.Top, Width:=aCell.Width, Height:=aCell.Height)
      cb.Placement = xlMoveAndSize
      cb.Name = "ComboBoxN1"
      cb.ListFillRange = "N1"
      cb.OnAction = "N1.value"
  
  Next
  
  End Sub
  </code></pre>
  
  <p>Please help.</p>