User form combo box size - VBA

0
votes

I have a user form which includes many combo boxes and i m wondering if there is a way to decrease the size of each line in a drop down list. As you can see in the image below the size of the row are very big in comparison with the word size and the top part of the combo box. after change Listwidth property a scroll bar appears in the combo box.

Combo box values are imported using loop. Any suggestions?

Combo Box

vh

After changing Listwidth propert

enter image description here

1
excelvbacomboboxuserform

1 Answers

2
votes

You can use the .ListWidth property. The units it uses are pt.

You can either set this at design time in the properties pane, or at run-time using code:

ComboBox1.ListWidth = 20

You can also change the .ColumnWidths property if you do not want the horizontal scrollbar to display.