Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ListBox missing last item
I can't figure out why the last item I add to a listbox is not showing up.
The scroll bar on the right is offset about 1/8" from the bottom, but when I make it scroll down all of the way, it pops back up - refusing to show the last item (which I presume is there, but hidden) I have a total of about 30 items with the ListStyle set to 1-fmListStyleOption, and MultiSelect set to 1-fmMultiSelectMulti. I've tried populating it with an array and by using .AddItem in a FOR-NEXT loop. Debug.Print for the last array item shows it correctly in the Immediate Window, so I know the value for the last item is not missing from the array (arProductGroups) ---------------------------------------------------------------------------------- The ARRAY Method: With .listProdGroups .List = Application.Transpose(arProductGroups) End With ---------------------------------------------------------------------------------- FOR-NEXT method: With .listProdGroups For i = 1 To UBound(arProductGroups, 2) .AddItem arProductGroups(0, i) Next End With ---------------------------------------------------------------------------------- I don't recal having this problem before I converted the workbook from Excel 2003 to Excel 2007. Anyone else seen this behavior? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Item from Listbox by Item Name | Excel Programming | |||
Double click item in Listbox to select item and close Listbox | Excel Programming | |||
listbox add item | Excel Programming | |||
Last item in listbox not getting displayed.- - Excel VBA appln. | Excel Programming | |||
The value of a ListBox Item | Excel Programming |