Delete the scroll bar in the list

Question

I am using userForm in vba and I have a list. I want to remove horoz. scroll bar below. Is there any way to do this? I do not see any option in the properties window.

Answer 1

This can happen if you have the column width property in the list set to something wide, and then you define a data control, it displays scroll bars.

To fix this, change the “Column Width” property on the format tab to something really small, and then play around with this property and the size of the list control until you get it the way you want and the scroll bars are displayed.

Answer 2

listbox ... mucn , , .

, .

Answer 3

Userform. " " KeepScrollBarsVisible.
0 - fmScrollBarsNone

- ListBox. !

Answer 4

!

Answer 5

ListWidth combobox , ColumnWidth.

The first size that you display on the screen, and the second size that you want to fit inside the first.