multipul lines in a cell

[Jim Peterson]

I was wondering if there is a way to make multiple lines in a cell using
visual basic. I know that in excel you can press ALT+ENTER and do this, but
I cannot figure it out using visual basic. Thanks in advance.
Jim

 

[Paul D]

How about something like this
Cells(1, 1).Value = "first line text" & Chr(10) & "second line text"
Paul D

 

[Tom Ogilvy]

activecell.Value = "ABCD" & chr(10) & "CDEF"

format the cell to wrap text.

 

[excel]

Hit ALT+ENTER

-----Original Message-----
How about something like this
Cells(1, 1).Value = "first line text" & Chr(10) & "second line text"
Paul D

ALT+ENTER and do this,
but


.