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
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
Views 3,759
Downloads 1,448
CodeID
DB ID
