View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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