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 liekly will change the height of listbox to adjust to scroll bar and scrolling.
This attachment hopefully describes the issue and how to fix it

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

Views 1973 Downloads 809

'Scroll', 'listbox', 'height', 'item', 'items', 'grid', 'list-box', 'adjust'

UI VBA-Excel