Returning newline from a function to a cell

[Dave Dixson]

I am trying to create a function that returns a string with a newline,
which when shown in a cell forces the cell to show on muliple lines as
if alt+enter was pressed.

Here is a test function I have tried....

Public Function getString() As String
getString = "hello" & vbLf & "worl"
end function

Unfortunatly, when I reference this function from within a cell in
excel it does not have the desired effect - it shows the new line as an
uprintable character (a rectangle appears in the cell), and the whole
string is shown on one string.

Anyone know what characters I should return from my function to get it
to display as a soft return in the cell?

Cheers,

Dave.

 

[Bob Phillips]

Public Function getString() As String
getString = "hello" & Chr(10) & "world"
End Function


you will need to set wrap text on the cell as well

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dave Dixson]

Thanks - it was the wrap text that was the problem. I did not realsie
that when you press alt+return in the spreadsheet that it sets this
automatically.

Dave.