listbox sizeing problem

[john.9.williams]

I hav a userform with a listbox on it, sometimes my listbox seems to
get bigger and the botom of the listbox moves to the bottom of the
form, is there some locking properties that i should be doing to keep
the form the size that i make it

regards
john

 

[Jim Rech]

A list box should never change size on its own, John. Aside from code
changing the height of the listbox or changing the Zoom of the userform
itself, I don't know why that would happen.

--
Jim
|I hav a userform with a listbox on it, sometimes my listbox seems to
| get bigger and the botom of the listbox moves to the bottom of the
| form, is there some locking properties that i should be doing to keep
| the form the size that i make it
|
| regards
| john
|

 

[Guest]

I am experiencing a similar problem, but in my case the listbox is reduced in
height after it is populated. I too am searching for a solution.

 

[Guest]

I am also experiencing a similar problem. Specifically, I have a listbox
where the height and width are modified after the list is repopulated. The
resizing only occurs when the zoom setting of the worksheet is other than
100%. If the zoom is less than 100%, the listbox will shrink on repopulation,
and if the zoom is greater than 100% it will grow in size on repopulation.
Moreover, it happens specifically when the list box is repopulated, not just
when I change the ListFillRange property. (For example, I have the listbox
ListFillRange property set to a range of cells on another worksheet. When
those cell values change, the listbox's list values change, and - if the
worksheet is zoomed at other than 100% - the listbox size is altered. I have
not yet determined any specific pattern to or "rule" to the alteration in
size, but it is clearly not simply trying to fit the size to the list
contents.

 

[ilyaskazi]

Dear all, try this...

Type this in userform intialize procedure:

Code
-------------------

Private Sub UserForm_Initialize()

listBox1.IntegralHeight = False
listBox2.IntegralHeight = False

end sub