View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSL[_2_] MSL[_2_] is offline
external usenet poster
 
Posts: 4
Default 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