Wrap text in a control listbox

[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

 

[Dave Peterson]

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

 

[Luke Alcatel]

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

 

[Jon Peltier]

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
_______

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

 

[Dave Peterson]

That's what I meant.

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