Cutting and pasting large variable text into a text box shape usin

=?Utf-8?B?QUpM?=

Guest

Posts: n/a

30th Oct 2006

Hello,

I am trying to create a macro that copies and pastes the resultant text of a
column of vlookups into a text box(shape). The text returned can be rather
lengthy, and not all the cells will necessarily return their text all the
time.
My question is, is it possible to overcome the 255 character string
limitation in VB in order to copy and paste all the text from a cell into the
text box before moving on the the next cell? I would also like the text from
a new cell to appear on a new line, and blank cells not to appear at all. Is
this possible?

Thanks,

Alan Lueke

« customized toolbar buttons macros to a group of users | Determine if Excel is running in a browser window »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HELP! - Cutting and Pasting Data into Text Box?	Trng_Chickster	Microsoft Access Forms	2	3rd Feb 2010 02:43 PM
Cutting and Pasting Text with Different Styles	Penny	Microsoft Word Document Management	1	8th Mar 2009 12:00 PM
manipulating/cutting/pasting text out of a text box	=?Utf-8?B?SmdpbGxpc0BhcmNoaXRldHRvLmNvbQ==?=	Microsoft Word Document Management	18	9th Jul 2006 10:54 PM
manipulating/cutting/pasting text out of a text box	=?Utf-8?B?SmdpbGxpc0BhcmNoaXRldHRvLmNvbQ==?=	Microsoft Word Document Management	0	2nd Jul 2006 01:43 AM
Cutting and Pasting Redlined Text	=?Utf-8?B?Um9iZXJ0IExvbWJhcmRv?=	Microsoft Word Document Management	1	23rd Jan 2004 03:22 PM