Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, you might not notice it, but I did.
At design time, height is set to grid of userform, but when item is added at run time, it most likely will change the height of listbox to adjust to scroll bar and scrolling.
This attachment hopefully describes the issue and how to fix it.

In short, you need to follow steps below to force it to the height you want

CodeFunctionName
What is this?

Public

Tested

Original Work
Code in attached Excel has example of issue and fix, and it is open for use

In short, you need to follow steps below to force it to the height you want
    Lst3DB.Height = 55
    Lst3DB.IntegralHeight = False
    Lst3DB.IntegralHeight = True
    Lst3DB.Height = 55

Views 3,680

Downloads 1,412

CodeID
DB ID