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 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