combobox population
 

Help, I have been all over the internet, etc. looking for help. I can't seem to populate a combobox using a variable sized list. I have tried many things but here is my latest attempt...

the data is from a call to a database that returns values to an excel spreadsheet. I want the results of the query to then populate the combobox. I can use the combobox from the forms menu, but it doesn't give me what I need. Can someone please help me?

TIA,

Dan

Sub populate_ab_combobox()

a = 3
Set n = Sheets("Inputs")

Do While n.Cells(1 + a, 19).Value < ""
ab_title = n.Cells(1 + a, 19).Value
a = a + 1
lastrow = a
n.cbx_ab_qry.AddItem ab_title
Loop

End Sub