How to Dynamically Change the Size of a Frame and Scrollbar on an Excel UserForm
I have a list of names on a spreadsheet that I am dynamically adding to a UserForm. The list is variable resulting in the need to dynamically build the list. The names are contained within a frame on the UserForm.
How can I adjust the size of the frame and scrollbar based on the number of names placed on the form?
I thought I could simply change the frame height and scrollbar height as the names were being placed on the form but this apparently does not work. (See attached)
Any help that you can provide would be greatly appreciated.
reduces the height significantly.