Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Asci equivalent of soft return (alt+enter)
Hi All,
What is the asci combination required to create the equivalent of pressing alt+enter when in a cell? I.e. I want to print the words "Cat" and "Mat" in the same cell but on different lines using VBA? TIA Andi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Asci equivalent of soft return (alt+enter)
Try:
Sub trial() Cells(5, 1).Value = "Cat" & Chr(10) & "Mat" End Sub -- Gary's Student "Andibevan" wrote: Hi All, What is the asci combination required to create the equivalent of pressing alt+enter when in a cell? I.e. I want to print the words "Cat" and "Mat" in the same cell but on different lines using VBA? TIA Andi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Asci equivalent of soft return (alt+enter)
With ActiveCell
..Value = "Cat" & vbLf & "Mat" ..WrapText = True ' normally done automaically End With Regards, Peter T "Andibevan" wrote in message ... Hi All, What is the asci combination required to create the equivalent of pressing alt+enter when in a cell? I.e. I want to print the words "Cat" and "Mat" in the same cell but on different lines using VBA? TIA Andi |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Asci equivalent of soft return (alt+enter)
Thank's
"Gary''s Student" wrote in message ... Try: Sub trial() Cells(5, 1).Value = "Cat" & Chr(10) & "Mat" End Sub -- Gary's Student "Andibevan" wrote: Hi All, What is the asci combination required to create the equivalent of pressing alt+enter when in a cell? I.e. I want to print the words "Cat" and "Mat" in the same cell but on different lines using VBA? TIA Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to insert a soft return into a single cell | Excel Discussion (Misc queries) | |||
soft return | Excel Discussion (Misc queries) | |||
Code equivalent to the Enter-Key | Excel Programming | |||
VBA equivalent to "Return/Enter" Key | Excel Programming |