<div>
It chokes on a carriage return, so the trick is to just use a line feed.
</div>


It chokes on a carriage return, so the trick is to just use a line feed.

<div>
Thanks Paul,<br />
seeing it i am somewhat ashamed lol,<br />
i can't believe i looked over vbLf...<br />
<br />
thanks again,<br />
cheers<br />
Ricky
</div>


Thanks Paul,
seeing it i am somewhat ashamed lol,
i can't believe i looked over vbLf...

thanks again,
cheers
Ricky

<div>
<div class="content wysiwyg-content">
Hi, <br />
whenever i export data from, for example a textbox with multiline enabled, to MS Excel, it will show me squares in the excel sheet for each vbCrlf there was in the textbox.<br />
<br />
Here's an example of the code:<br />
<br />
*********<br />
xlSht.Cells(3, 1).Value = &nbsp;txtRoot(1).Text<br />
*********<br />
<br />
Assuming the txtRoot(1) has this data in it:<br />
26578<br />
3246<br />
3444<br />
<br />
Then it wil show a square after each number once it is inside a cell in Excel.<br />
<br />
How to trap this? (and replace by ALT + ENTER ?)<br />
<br />
cheers<br />
Ricky
</div>
</div>


Hi, 
whenever i export data from, for example a textbox with multiline enabled, to MS Excel, it will show me squares in the excel sheet for each vbCrlf there was in the textbox.

Here's an example of the code:

*********
xlSht.Cells(3, 1).Value =  txtRoot(1).Text
*********

Assuming the txtRoot(1) has this data in it:
26578
3246
3444

Then it wil show a square after each number once it is inside a cell in Excel.

How to trap this? (and replace by ALT + ENTER ?)

cheers
Ricky

Export to Excel: vbCrlf

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.