Userform - combo box

Question

Hello,

Im trying to create a data entry form which has dropdown using the combo box. I would like to know how to expand to see the whole drop down as it has long phrases and i dont like to change the Height, Left, Top and Width. Also i would want to know how to word wrap once the dropdown is selected.

Height 30

Left 264

Top 54

Width 114

Thanks,

Mark

Answer 1

You cannot wrap text in a combo box or list box.

You might place a label next to the combo box, and make it tall enough to display multiple lines of text.

In the Change or Click event of the combo box, set the Caption of the label to the currently selected item of the combo box.

Answer 2

What I am wanting to wrap text is the combo box itself and not the cell.

Answer 3

You only need to turn on Wrap Text for the cell(s) with the drop-down once, before starting to select items.

Answer 4

It worked.

I would want to know how to word wrap once the dropdown is selected. Is this possible.

Answer 5

You can set the ListWidth property of the combo box. This specifies the width of the drop-down list. For example, if you set it to 228, the drop-down list will be twice as wide as the combo box.