show multiple separate information

[suculeiz1]

Determine that a combobox receives information from a column, but with the possibility of including more box and column


Sub test()Dim i As Long
With Sheets("ws1")
For i = 4 To 6
controls("Combobox" & i).Object.List = Range("A1:A" & .Cells(.Rows.Count, "A").End(xlUp).Row))
Next i
End With
End Sub