List Box: Wrap text?
 

How does one wrap text in a listbox? There is not a "multiline"
property...Is there another way to accomplish the same?

-- Jason Sweeney


--
jasonsweeney
------------------------------------------------------------------------
jasonsweeney's Profile: http://www.excelforum.com/member.php...fo&userid=5222
View this thread: http://www.excelforum.com/showthread...hreadid=508577

List Box: Wrap text?
 

As far as I know it does not support this....

Tim


"jasonsweeney"
wrote in message
news:jasonsweeney.22qaby_1139095801.4394@excelforu m-nospam.com...

How does one wrap text in a listbox? There is not a "multiline"
property...Is there another way to accomplish the same?

-- Jason Sweeney


--
jasonsweeney
------------------------------------------------------------------------
jasonsweeney's Profile:
http://www.excelforum.com/member.php...fo&userid=5222
View this thread: http://www.excelforum.com/showthread...hreadid=508577

List Box: Wrap text?
 

If its not supported, the only way I can think of mimicing the same is
to hide the listbox on the form, and then put 4 or 5 textboxes (each
with multi line turned on, probably also with a vertical scroll bar) in
a vertical row. Then update the textboxes using "textbox1.value =
listbox.listindex 1"...

Hell, for that matter, I could skip the listbox completely, and just
use textboxes...

But it would be far easier to just have the listbox wrap my text!

-- Jason


--
jasonsweeney
------------------------------------------------------------------------
jasonsweeney's Profile: http://www.excelforum.com/member.php...fo&userid=5222
View this thread: http://www.excelforum.com/showthread...hreadid=508577

List Box: Wrap text?
 

You could use a regular listbox and split your long lines up into two (or
more) lines. Handle clicks such that they select all linked lines when any
one of the (split) lines is selected. A bit complex since you'd have to
keep track when you loaded the list which lines are related, but should be
possible.


Tim




"jasonsweeney"
wrote in message
news:jasonsweeney.22qcna_1139098801.2485@excelforu m-nospam.com...

If its not supported, the only way I can think of mimicing the same is
to hide the listbox on the form, and then put 4 or 5 textboxes (each
with multi line turned on, probably also with a vertical scroll bar) in
a vertical row. Then update the textboxes using "textbox1.value =
listbox.listindex 1"...

Hell, for that matter, I could skip the listbox completely, and just
use textboxes...

But it would be far easier to just have the listbox wrap my text!

-- Jason


--
jasonsweeney
------------------------------------------------------------------------
jasonsweeney's Profile:
http://www.excelforum.com/member.php...fo&userid=5222
View this thread: http://www.excelforum.com/showthread...hreadid=508577