Populate Excel Problem

[doctrin13th]

Populating a worksheet with text from a single line textbox, that I got working.
But whenever I put contents to a cell from a multiline textbox or even a richtextbox, the newline character turns into a square. Same with Tab.
How can I prevent the program putting ascii characters instead of the actual carriage return(Enter key) or the tab key?

is there a way?

[anhn]

1. Tab character cannot be displayed in a cell --> Tab turns to square
2. Line break in Excel cell use vbLf = Chr(10) while line break in Textbox use vbCrLf = Chr(13) & Chr(10) --> Chr(13) turns to square
You also need to turn on Wrap Text for the cell.

Some thing like:

ws.Range("A1") = Replace(Replace(Text1.Text, vbCrLf, vbLf), vbTab, " ")

[Hack]

Moved To Office Development