Thread: listbox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ranswrt ranswrt is offline
external usenet poster
 
Posts: 191
Default 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