excel - Sometimes the ActiveX Combobox only shows one row, why? -

it seems when first click on combobox , click on arrow, items displayed.

while if click on arrow without clicking on combobox before, 1 item displayed , can click on scroll buttons see other items.

why happen?

here macro using populate combobox items

private sub combobox1_gotfocus()     dim c range     dim seltext string     seltext = combobox1.seltext     combobox1.clear     each c in wconfig.range("budgetdropdown").cells         combobox1.additem c.value     next c     combobox1.seltext = seltext end sub 

to automatically populate combobox data named range, set it's listfillrange property name of range.

you can @ runtime:

combobox1.listfillrange = "budgetdropdown" 

or setting budgetdropdown in properties window.