View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Copy text from cell and paste it in a separate text box (contents to be linked)


Again, Detail and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"andreashermle" wrote in message
...
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