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.

DavidS wrote:

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

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" wrote in message
...
I think you'll find that you can't do this.

DavidS wrote:

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 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" wrote in message
...
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" wrote in message
...
I think you'll find that you can't do this.

DavidS wrote:

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

That's what I meant.


Luke Alcatel wrote:

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" wrote in message
...
I think you'll find that you can't do this.

DavidS wrote:

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

--

Dave Peterson