Posted to microsoft.public.excel.programming

MSL[_2_]

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text and TextBox problem	Stuart[_5_]	Excel Programming	3	July 26th 04 12:52 AM
Textbox problem	Robert Couchman[_4_]	Excel Programming	11	February 26th 04 02:01 PM
Problem with TextBox & ControlSource - Please Help	[email protected]	Excel Programming	8	January 14th 04 06:45 AM
TextBox SetFocus Problem	Tom Ogilvy	Excel Programming	1	September 12th 03 01:27 PM
Excel textbox problem	numcrun	Excel Programming	0	July 16th 03 10:05 AM

All times are GMT +1. The time now is 11:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us