Listbox scretch

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hello, I added a listbox in my main sheet. The only property changed is the
"listfillrange" (linked to another sheet/range A3:A200). Each time i load the
file, the listbox is smaller and smaller... How can i fix this problem ?
 
Jean,

In design mode, right click the listbox and change the IntegralHeight
property to False.

Does this correct the problem ?

Skiffle
 
Jean,

In my original post, I didn't direct you to IntegralHeight accurately.

In design mode, right click the listbox, choose properties and then change
the IntegralHeight
property to False. If this does not work, right click the listbox, choose
Format Control --> Properties Tab and select 'Move but don't size with
cells' --> OK

Cheers
 
Back
Top