ExcelBanter

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

ranswrt

listbox
 
I have a listbox on a userform that I adjust the height depending on the
number of items in the rowsource. The font size is 8 and I take the number
of items and multiply by 9.75 to set the height of the listbox. I also have
the max height set at 214.5. I currently have 50 item in my rowsource. The
problem I am having is that when I scroll down to the final ltem only the top
1/4th is showing in the listbox.

What am I doing wrong?
Thanks


All times are GMT +1. The time now is 08:30 AM.

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