Solved: how to display all options of a combo box

[circaa]

Hi

Easy one for you guys :

My combobox seems to have a display range of 8 options, for any more than that you have to scroll down. The problem is that i have 15 of them and I want them to be visible without having to scroll down.

anyone know how to change the display range ?

[mvidas]

Hi circaa,

One of the properties of a ComboBox is the "ListRows" property - the default for that is 8, you can either change it to 15, or set [vba]yourcombobox.listrows=yourcombobox.listcount[/vba] if you always want to see all of them.

Matt

[circaa]

thanks a lot Matt

[mvidas]

Glad to help!