Excel VBA - Listbox value too long for window. Line break? RRS feed

  • Question

  • Is it possible to add a line break on a single choice in a listbox? I have a listbox that's populated from a oft-updated spreadsheet, the authors of which seem to feel the need to have 300 characters in a single cell. Anyway, when I pull this into a listbox, of course I can't have a userform that takes up the entire screen so I need a way to either create a line break in a single list option or to have a controltip show the entire value on hover.

    Excel 2003.

    Any help is greatly appreciated!

    Monday, August 22, 2011 8:49 PM