View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dsimcox dsimcox is offline
external usenet poster
 
Posts: 18
Default Excel 2007 listbox width problem

I have a multicolumn listbox that has a defined height and width.
IntegralHeight is set to true.

Sometimes, when the userform containing the listBox is opened, the width of
the listbox has shrunk so that some of the columns are not visible. If I
click on the listbox, it will expand to the correct width.

I've tried everything I can think of to get the listbox to size properly
when opened, including re-defining the Height and Width properties in the
code that is executed when the userform opens, but without success.

Is there a way to make the listbox behave better?