Unexpected changes to Listbox height

[PickingUp]

I'm using VBA code in Excel 2003 and I set the height of a listbox at runtime. Unfortunately, the end result is different than what I programmed it to be.
A bit of debugging (stepping through line by line and watching the Locals window) reveals that the code in fact does initially set the height to the desired number. But each time the code sets another property of the listbox (RowSource, ColumnWidth, Font size) the height changes unexpectedly.
Any ideas?

 

[p45cal]

"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. "

 

[PickingUp]

It worked! Thanks a lot!

I would still like to know why it should make a difference. I mean, the Font size could affect the balance of the height, but how would RowSource or ColumnWidth cause a change in integral height?

Puzzled in New Jersey

 

[p45cal]

It worked! Thanks a lot!

I would still like to know why it should make a difference. I mean, the Font size could affect the balance of the height, but how would RowSource or ColumnWidth cause a change in integral height?

Puzzled in New Jersey

Does the height adjust itself more than once when these properties are changed, or just once?

 

[PickingUp]

The code changed the RowSource. The Height changed.
The code changed the ColumnWidths. The Height changed again.
The code changed the Font Size. The Height changed a third time.

The problem you've already solved. Just it would be nice to understand what was happening and you never know when such knowledge could come in handy. But I don't want to trouble anyone to break their heads on a theoretical problem.