Listbox scretch

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 ?
 
S

Skiffle

Jean,

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

Does this correct the problem ?

Skiffle
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top