Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Combobox Population | Excel Programming | |||
ComboBox Population of Cell Range | Excel Programming | |||
Userform text & combobox population help required please | Excel Programming |