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

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 Boldcodes.com

Linkedin Login

Views 3,759

Downloads 1,448

CodeID
DB ID