| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox9.Text = Range("J:J") --- New line for each cell with a value?
Hello Fellow Programmers!
I am in need of some assistance with getting a text box to accept a range of cells and put the contents of each value inside the textbox on a seprate line...I have been messing around with some of the code and managed to get it to work correctly however I know there is a better code to use instead of the following... TextBox9.Value = Range("J6") & vbLf & Range("J7") & vbLf & Range("J8") & vbLf & Range("J9") & vbLf & Range("J10") & vbLf & Range("J11") & vbLf & Range("J12") My code in my dreams works like this... TextBox9.Value = Sheet1.Range("J:J") & vbLf vbLf would only apply to nonblank values...example below. J1 = Value NEW LINE (vbLf) J2 = Value NEW LINE (vbLf) J3 = Empty No Line Thanks! Hope to get some feedback... -Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I "keep text together" within a cell to keep it on 1 line? | Excel Discussion (Misc queries) | |||
| Combine text from multiple cells into one cell - =(A1&","&A2","&A3 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Threaded Mode
