Wrap text in a control listbox

  • Thread starter Thread starter DavidS
  • Start date Start date
D

DavidS

Hello, I have a number of lines in a listbox taken from the Control Toolbox
that I would like to wrap to the width of the listbox. Do you know which
property should be set or whether it has to be wriiten in VBA. Would
appreciate any pointers or suggestions. Many thanks for you help. David
 
I think you'll find that you can't do this.
Hello, I have a number of lines in a listbox taken from the Control Toolbox
that I would like to wrap to the width of the listbox. Do you know which
property should be set or whether it has to be wriiten in VBA. Would
appreciate any pointers or suggestions. Many thanks for you help. David
Click to expand...
 
Dave,
The question was a little specialized wrt wrapping at the width of the
listbox. Does your answer mean you don't know of a way to wrap text within
cells of an MSForms.ListBox using Excel/VB?

LA
 
I don't know exactly what Dave meant, but I have never seen a way to wrap
text in a list box. You're limited to one row (one line) per list item.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Luke Alcatel said:
Dave,
The question was a little specialized wrt wrapping at the width of the
listbox. Does your answer mean you don't know of a way to wrap text
within cells of an MSForms.ListBox using Excel/VB?

LA
Click to expand...
 
That's what I meant.


Luke said:
Dave,
The question was a little specialized wrt wrapping at the width of the
listbox. Does your answer mean you don't know of a way to wrap text within
cells of an MSForms.ListBox using Excel/VB?

LA
Click to expand...
 
Back
Top