I'm afraid that you need a macro to fix the size of the list. I had this
problem myself and called the macro from a worksheet_change event and also on
opening.

The way is worked was to link the size to an input range height - if the row
height changed (due to wrapping text) then so did the list box.

Reply if you want to go down the macro route.

Peter Atherton

"kumik5000" wrote:

Hello

I made a listbox using the control toolbox option but every time I "save as"
and open the spreadsheet, the size of the listbox changes. It usually shrinks
so that you can't read the list options inside.

Is there any way to keep that from happening? If there's a way without
having to use VBA (as I'm not familiar) that would be great.

Thanks for your help.