View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul D[_2_] Paul D[_2_] is offline
external usenet poster
 
Posts: 38
Default multipul lines in a cell

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

"Jim Peterson" wrote in message
...
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