The VB Help description ...
The IntegralHeight property relates to the height of the list, just as the AutoSize property relates to the width of the list.
"If IntegralHeight is True, the list box automatically resizes when necessary to show full rows. If False, the list remains a fixed size; if items are taller than the available space in the list, the entire item is not shown."
I can't seem to get any difference in this property - TRUE or FALSE. Conversely, the AutoSize property works as described.
Is there anyone who knows how to use this property to get the textbox height to adjust with multiple lines / rows?
Daniel
The easiest way to see the effect of IntegralHeight is with a listbox on a userform. Create one. Link it to some cells in a sheet using the RowSource property. Make sure those cells have some information in them.
Now, try to resize the listbox in the userform vertically. You'll find that with IntegralHeight set to True, the listbox will jump from one size to another such that you can see the next line completely (or not at all). With IntegralHeight set to False, the vertical size can be adjusted smoothly so that only a part of the next line becomes visible.
#If you have any other info about this subject , Please add it free.# |