I have a lot of experience with Excel and Excel VBA, but I can't figure out
something that should be really simple. How do you go to/create a new line in
a cell? Say you're typing text in a cell, and then you want to make a new
paragraph or put in some bullets IN THE SAME CELL, how is this done?

(I know it can be done by inserting new rows or going to the next cell, but
this is cumbersome and requires constant updating to cell formatting.)

Hi

Sub Test()
With Sheets(1).Range("A1")
.WrapText = True
.Value = "Hi Mom" & Chr(10) & "This is great" & _
Chr(10) & Chr(10) & "James"
End With
End Sub

Manually it's done with Alt Enter.

HTH. Best wishes Harald

"exceller" skrev i melding
...
I have a lot of experience with Excel and Excel VBA, but I can't figure
out
something that should be really simple. How do you go to/create a new line
in
a cell? Say you're typing text in a cell, and then you want to make a new
paragraph or put in some bullets IN THE SAME CELL, how is this done?

(I know it can be done by inserting new rows or going to the next cell,
but
this is cumbersome and requires constant updating to cell formatting.)