Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox integral 'width'?
Hello all,
Is it possible to 'textwrap' an entry in a listbox so that if the length of text exceeds the width of a listbox, it wraps/continues in the row beneath? Example: I have a spreadsheet where a listbox resides. With the list box there is a commandbutton that will enter the text of a textbox into the listbox via additem. I have managed to make it work by using the mid and len worksheet functions where if the text length exceeds the width of 42 characters (close to the length of the listbox): Dim txt1 As String Dim txt2 As String Dim txt3 As String txt1 = "Plyr 1: " & TextBox1.Text Worksheets("sheet2").Range("a21") = txt1 txt2 = Worksheets("sheet2").Range("h22").Text txt3 = Worksheets("sheet2").Range("h23").Text ListBox1.AddItem (txt1) If txt2 < "" Then ListBox1.AddItem (txt2) End If If txt3 < "" Then ListBox1.AddItem (txt3) End If I picked the length of 42 because I typed in 1thru 60 to see how many would fit. I know that not all characters are the same length, but this seems to work for the most part. I have to think there is a better way. Is there? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use an integral for cell output value. | Excel Discussion (Misc queries) | |||
definite integral | Excel Worksheet Functions | |||
How to do integral calculus in Excel spreadsheet? | Excel Worksheet Functions | |||
Listbox Column Count and Width Dont work. Seems Easy | Excel Programming | |||
ListBox with variable width columns ? | Excel Programming |