Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Userform ComboBox Text (XP)

    I have a combobox in a userform that is set for a specific width. The rowsource of the combobox is populated from a range of cells. One of the lines of text in the range of cells is longer then the width of the combobox and therefore some of the text is cut off when viewed by clicking on the dropdown of the combobox.

    Is it possible to wrap the text or auto-adjust the combobox for the length of text?

    Your suggestions are appreciated.
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Userform ComboBox Text (XP)

    You can't wrap text in a combo box (or list box).
    Adjusting the width of the dropdown list is possible in theory, but it would be complicated. I'd make the list width large enough for the widest possible entry - and if possible limit the length of the entries. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •