LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 123
Default Copy text from cell and paste it in a separate text box (contents tobe linked)

Dear Experts:

With some cells in a colum selected (say 10 selected cells in a
column: contiguous range) I would like a macro to copy the contents of
these cells and paste the contents of each cell in separate text
field.

Now here it comes. The pasted contents in the text field should be
linked to the cell contents, i.e. whenever the cell's contents is
changed, the contents of the text field should reflect this. Is this
feasible?


Help is much appreciated. Thank you very much in advance.


Regards, Andreas


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copy cell contents, then paste into the same cell with other text. bluenote31 Excel Discussion (Misc queries) 4 February 9th 10 09:18 PM
Copy contents of a cell and paste it into text field andreashermle Excel Programming 1 December 12th 09 01:46 PM
Can I copy cell contents to an autoshape as text using a macro? Syndrome Excel Programming 1 July 11th 06 01:16 PM
How do I copy the contents of a range of text cells and paste into one cell? davfin Excel Discussion (Misc queries) 7 July 4th 06 08:16 AM
Open multiple text files and paste contents to single cell [email protected] Excel Programming 1 October 19th 05 04:05 PM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"