Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |