View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJL AJL is offline
external usenet poster
 
Posts: 18
Default Copy from a Cell to a text box.

Hello,
I am trying to copy and paste the text returned by several vlookup formulas
to a text box. The amount of text returned to the cells is quite large.
When I set the text box equal to one of the cells, only a portion of the text
appears in the text box. When I set it equal to a range of cells I get
nothing. Is it possible to generate a macro that will copy and paste large
amounts of text that result from numerous equations into a text box?
Thanks.

-Alan Lueke