Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Excel 2007; even though "Wrap Text" is on the text does wrap? | Excel Discussion (Misc queries) | |||
Wrap text doesn't wrap | Excel Worksheet Functions | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
How can I wrap text in a drop down list? | Excel Worksheet Functions |