View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pfa
 
Posts: n/a
Default Copy text from text box to cell in another worksheet

This is a re-post (original 6/21), much summarized and, hopefully a lot
clearer...Any assistance is greatly appreciated.

I have a tab labeled I-16 where I have a text box (text box 2). I would like
to have the text in the box copied to cell J45 on a tab named 'database'.
Both tabs are on the same workbook.

Also, the text is more than 1,024 characters long, so there may a problem
when it gets copied over to cell J45.



Thanks!