ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox (https://www.excelbanter.com/excel-programming/409634-listbox.html)

ranswrt

Listbox
 
I am having a problem sizing a listbox on a form. The number of items
changes in the list. I multiply the number of items by 9.95 and set the
height to this. The maximum height is 208.95. When the list is longer than
21 items and I scroll to the bottom the last Item isn't showing.

Is there a better way to change the height of the listbox dependant on the
size of the list?
Thanks

[email protected]

Listbox
 
On Apr 19, 1:43*am, ranswrt wrote:
I am having a problem sizing a listbox on a form. *The number of items
changes in the list. *I multiply the number of items by 9.95 and set the
height to this. *The maximum height is 208.95. *When the list is longer than
21 items and I scroll to the bottom the last Item isn't showing.

Is there a better way to change the height of the listbox dependant on the
size of the list?
Thanks


Hi,

The question is not very clear to me. ListBoxes have scrollbars when
the list they contain has more items than can be shown on one ListBox
screen.

Thanks
Anant


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com