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
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
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,692
Downloads 1,423
CodeID
DB ID