ExcelBanter - Textbox/Cell Problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Textbox/Cell Problem (https://www.excelbanter.com/excel-programming/335016-textbox-cell-problem.html)

MSL[_2_]

Textbox/Cell Problem

Whenever i copy text from a text box to a cell, all new lines appear with a
square at the end of it. Anyone know how to stop these squares from
appearing.
Many thanks

K Dales[_2_]

Textbox/Cell Problem

CopyTxt = ActiveSheet.TextBox1.Text
CopyTxt = Replace(CopyTxt,vbCrLf,vbLf)
Range("A1")=CopyTxt
--
- K Dales

"MSL" wrote:

Whenever i copy text from a text box to a cell, all new lines appear with a
square at the end of it. Anyone know how to stop these squares from
appearing.
Many thanks

MSL[_2_]

Textbox/Cell Problem

Thats a great help
many thanks

"K Dales" wrote:

CopyTxt = ActiveSheet.TextBox1.Text
CopyTxt = Replace(CopyTxt,vbCrLf,vbLf)
Range("A1")=CopyTxt
--
- K Dales

"MSL" wrote:

Whenever i copy text from a text box to a cell, all new lines appear with a
square at the end of it. Anyone know how to stop these squares from
appearing.
Many thanks

All times are GMT +1. The time now is 07:18 AM.