Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
Hi all, Anyone know how to input 2 strings from vba into a single cell, like the following; String 1 String 2 Code: -------------------- Cells(1, 1).Value = "M/C Group By: " & GroupMachine & " " & "Shift Group By: " & GroupShift -------------------- The code above puts the strings into the cell without a break. Any help appreciated!! Taa laa -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=510524 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
activecell.Value = "a" & chr(10) & "b"
Robin Hammond www.enhanceddatasystems.com "gti_jobert" wrote in message ... Hi all, Anyone know how to input 2 strings from vba into a single cell, like the following; String 1 String 2 Code: -------------------- Cells(1, 1).Value = "M/C Group By: " & GroupMachine & " " & "Shift Group By: " & GroupShift -------------------- The code above puts the strings into the cell without a break. Any help appreciated!! Taa laa -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=510524 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
Hey, I had originally did as you tried but got a square inbetween my strings within the cell, found out that the cell first has to be formatted using 'Wrap Text box'. Taa -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=510524 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
Range("A1") = "String1" & Chr(10) & "String2"
maybe, "gti_jobert" wrote in message ... Hi all, Anyone know how to input 2 strings from vba into a single cell, like the following; String 1 String 2 Code: -------------------- Cells(1, 1).Value = "M/C Group By: " & GroupMachine & " " & "Shift Group By: " & GroupShift -------------------- The code above puts the strings into the cell without a break. Any help appreciated!! Taa laa -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=510524 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
Make it Range("A1")= String1 & CHR$(10) & String2 ( it is CHR$ not CHR ) A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=510524 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lines in single cell
"avveerkar" wrote in message ... ( it is CHR$ not CHR ) It's both. And there's very little to choose between the two. Chr$ is marginally more efficient, but will make such a disappearingly small improvement in an average Excel/VBA application that, in reality, it matters not which you use. Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add several lines of data in a single cell on a excell worksheet | Excel Discussion (Misc queries) | |||
Mulitple text lines in a single cell | New Users to Excel | |||
How to split wrapped text in a single cell into multiple lines | Excel Discussion (Misc queries) | |||
Need to add 2 or more lines of data into a single cell in Excel | Excel Discussion (Misc queries) | |||
Importing Multiple lines of text in a single Excel Cel | Excel Programming |