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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ListBox missing last item
"Anyone else seen this behavior?" Yes, but it wasn't in the 2007 version. You will have to change (increase/decrease) the height and or toggle the IntegralHeight setting for the listbox until the problem goes away. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "dsimcox" wrote in message 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) -snip- I don't recal having this problem before I converted the workbook from Excel 2003 to Excel 2007. Anyone else seen this behavior? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ListBox missing last item
Thanks, Jim . . . your suggestion solved my problem. I can see that the
listbox needs space for an "integral number" of list items - and by reducing the list box it allowed the items to display correctly with a scroll bar. Sorry to blame 2007 - it's the first thing that comes to mind when I have a problem these days. Appreciate your very helpful response yesterday. "Jim Cone" wrote: "Anyone else seen this behavior?" Yes, but it wasn't in the 2007 version. You will have to change (increase/decrease) the height and or toggle the IntegralHeight setting for the listbox until the problem goes away. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "dsimcox" wrote in message 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) -snip- I don't recal having this problem before I converted the workbook from Excel 2003 to Excel 2007. Anyone else seen this behavior? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ListBox missing last item
I'm seeing the same behavior, but I'm using Excel 2003, not 2007.
Do you happen to be running Windows Vista? I am, and that's when I started seeing this problem. |
Reply |
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 |