Load Combobox from row 17

[adamsm]

Hi,

The following code activates the userform from columns 1 to column 14 and headings from row 1.

Private Sub UserForm_Activate()
  
  With ComboBox1
    For i = 1 To 14
      .AddItem Cells(1, i)
    Next i
    .SetFocus
  End With
  
End Sub

How could I make the code to load data from row 16 of sheet "MySheet" from columns D to N?

Any help wpuld be kindly appreciated.

 

[mikerickson]

The syntax Cells(1, i) refers to row 1, column i.

So changing the 1 to 16 and looping i from 4 to 14 should do what you want.

 

[Norie]

Is it just those cells in that row?

Just change 1 to 4 in the for and 1 to 16 in Cells.

 

[adamsm]

Thanks for the help. Worked fine.