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?