[RESOLVED] Load ComboBox Ignore Header Skip Blanks

[billboy]

I want to load my combobox on sheet2 from data in sheet1

The data in sheet1 will vary in size it also contains column headres that i dont want loaded into the combobox

[seenu_1st]

i think u r using RowSource in combo, better use For Next loop, start loop from next row of the header, and if cell is not blank then add to combo.

[billboy]

i think u r using RowSource in combo, better use For Next loop, start loop from next row of the header, and if cell is not blank then add to combo.

give you give me an example I can tweak?

[seenu_1st]

something like this

Dim i As Long, LastRow As Long
With Sheet1
    LastRow = .Cells(Rows.Count, "A").End(xlUp).Row
    For i = 2 To LastRow    'concidered row 1 as header
        If .Cells(i, "A") <> "" Then
            .ComboBox1.AddItem .Cells(i, "A")
        End If
    Next i
End With