Removing return character taken from form into cell

[DrBowes]

I am taking data from textboxes to fill cells. The textboxes have Enterkeybehaviour and multiline set to true. The problem is when the values from the textboxes are put into a cell in Excel they contain a little square () where the returns were.

How can I stop these little squares showing in the cells?

I think something similar came up quite recently but I have not been able to find it.

Thanks very much in advance for your help.

DrB

 

[SkipVought]

Hi,

Try stripping vbCR & vbLF characters before assigning the value.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[xlbo]

In code:

range("A1&quot.text = replace(textbox1.text,char(10),"&quot

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244