Combo Box Rows 1

[boggg1]

Is there a way to display more rows when you drop down a standard combo box at run time ? I know in the Office version of the combo box (MSForms version) there is a ListRows property but there is no such thing in the true Visual Basic combo box.

The default value of number of rows is 8, I want 25 as there is a lot of data in my combo boxes.

The MSForms version is not strictly "allowed" under true Visual Basic...

http://support.microsoft.com/default.aspx?scid=kb;en-us;224305

Boggg1
[Bigglasses]

 

[strongm]

Sure. Check out my code in thread222-438535. There have been plenty of other posts in this forum that discuss similar solutions, so a keyword search will be useful if the linked thread doesn't do exactly what you need.

 

[boggg1]

Thanks, just what I needed. I did search for this but for some reason I missed it. Have a star for your help.

For the sake of others, after receiving your post I also found...

The same thing working from inches (or cm) rather than pixels...

http://www.freevbcode.com/ShowCode.asp?ID=1849

The definition of a Twip...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbdef98/html/vbdeftwip.asp

Thanks again.

Boggg1