Excel 2007 ListBox missing last item

  • Thread starter Thread starter dsimcox
  • Start date Start date
D

dsimcox

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?
 
re: "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?
 
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.
 
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.
 
Back
Top