combo box drop down won't show entire list

[BlueRidgeFoothills]

A combo box is set up with, say, listrows = 2.

It then shows two rows. Fine.

Now, when I go and change listrows to, say, 10.

It still only shows 2.

Basically, I can't get the combo-box dropdown to refresh when I put in a new # for listrows, to show a longer list

 

[RoryA]

Which version of Excel? Works for me in 2010. (I assume you have more than 2 items)

 

[BlueRidgeFoothills]

Thanks -

Using 2010 - I'll try to be very specific...

Click developer tab
Click design mode
Insert Active X combo box
Make a list on sheet named "test"
in cells below enter numbers 1, then 2 below
Set combo box properties ListFillRange 2
Combo box drop down works correctly, shows the numbers 1 and 2
Add in cells below to list named test, 3, 4, 5, 6
Go to formulas tab, then name manager, edit, and expand selection for "test" to include 3, 4, 5, 6. Hit checkmark, then close.
Go back to combo box. Mine only has 1, 2 showing up in drop down. Note: In combo box properties, "listrows" is set to 6.

So, I don't understand why when I go back to combo-box it doesn't display numbers 1-6 in drop down.

 

[RoryA]

I think your issue is that the list is not updating, rather than list rows being wrong. Try clearing and re-entering the ListFillRange.

 

[BlueRidgeFoothills]

You da man...was clearing listfillrows but didn't see need to change listfillname, same name...

Thanks!

 

[sriramvangara]

Found this as a valid solution even today on Excel 2016 on Windows. Thank you!!