Prev: Call a Sub from another Worksheet
Next: 2 codes in one sheet
From: Luke on 27 Apr 2010 11:25
I have a macro that takes cell data from a spreadsheet and populates a
ListBox. I have no problems getting the data I want into the ListBox, but
I'd like to make it look neater. Many of the items I add are longer than the
width of the ListBox. I'd like to wrap (and possibly indent?) such entries,
but I can't find a WordWrap property for the ListBox in the Properties
window. Does anyone know a way to do this?
From: Rick Rothstein on 27 Apr 2010 12:01
To the best of my knowledge, you cannot have multiline items in a ListBox
(without horizontal "grid" lines, I think it would be complicated to read).
However, assuming you are using an ActiveX control and not one from the
Forms toolbar, you can implement a horizontal scroll bar so the that the
long items can be read in their entirely... just set a ColumnWidths property
to a number of points large enough to allow the scroll bar to reveal all of
the text (you can do that by trial and error).

--
Rick (MVP - Excel)



"Luke" <Luke(a)discussions.microsoft.com> wrote in message
news:CA2B6356-84E1-4C9D-B96A-16637EF1B7C9(a)microsoft.com...
> I have a macro that takes cell data from a spreadsheet and populates a
> ListBox. I have no problems getting the data I want into the ListBox, but
> I'd like to make it look neater. Many of the items I add are longer than
> the
> width of the ListBox. I'd like to wrap (and possibly indent?) such
> entries,
> but I can't find a WordWrap property for the ListBox in the Properties
> window. Does anyone know a way to do this?

 | 
Pages: 1
Prev: Call a Sub from another Worksheet
Next: 2 codes in one sheet