Share via

Userform - combo box

Anonymous
2023-01-14T17:01:57+00:00

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

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. HansV 462.6K Reputation points
    2023-01-15T12:38:02+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-01-15T12:16:37+00:00

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

    Was this answer helpful?

    0 comments No comments
  3. HansV 462.6K Reputation points
    2023-01-14T19:17:52+00:00

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

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-01-14T17:20:16+00:00

    It worked.

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

    Was this answer helpful?

    0 comments No comments
  5. HansV 462.6K Reputation points
    2023-01-14T17:10:01+00:00

    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.

    Was this answer helpful?

    0 comments No comments