View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Ang[_3_] Francis Ang[_3_] is offline
external usenet poster
 
Posts: 75
Default Shrinking Listbox

I have placed a listbox in Sheet1. The listbox displays 10 items. I noticed
that everytime I open the Excel spreadsheet, the listbox shrinks and display
1 item less. The "shrinking" effect will stop when the listbox displays 3
items.

How do I stop this "shrinking" effect on the list box? Any help will be
very much appreciated.

Thank you.