listbox sizeing problem
 

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

listbox sizeing problem
 

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
wrote in message
ups.com...
|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
|

listbox sizeing problem
 

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.

" wrote:

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

listbox sizing problem
 

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.

"mrwaller" wrote:

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.

" wrote:

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

listbox sizeing problem
 

Dear all, try this...

Type this in userform intialize procedu

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

Private Sub UserForm_Initialize()

listBox1.IntegralHeight = False
listBox2.IntegralHeight = False

end sub

-------------------


HTH
ilyaskaz

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=46994