Your Right i did misunderstand the problem. Try not making the Listbox
visible until after you have adjusted the size properties.

"tommo_blade" wrote:

Ok I understand a little about accessing windows objects but I am
struggling to visualise how this will work with my problem, what I
think you are saying is this:-

In my present solution the listbox's are hidden until certain cells
are selected, at this point the listbox becomes visible and in that
listbox are the contents of a 'hidden worksheet' with the last row in
the listbox not being visible.

For your suggestion, when the cell is selected instead of the listbox
being presented the windows userform will be called (which can be
tweaked to any size) and this will display the contents of the hidden
worksheet.

One Question: what is the exact problem with the listbox, I can alter
the 'height' property of the box and it displays the whole data ok, it
is only after I close the spreadsheet and re-open that the problem
occurrs.

cheers.