On Dec 12, 6:17*pm, "Rick Rothstein"
wrote:
If on a worksheet, which toolbar did you get them from...
the Forms toolbar or the Control Toolbox toolbar?

That last question should have read this way...

If on a worksheet, which toolbar did you get them from... the **Drawing**
toolbar or the Control Toolbox toolbar?

--
Rick (MVP - Excel)

"Rick Rothstein" wrote in message

...



What does "text field" mean to you... other cells in your worksheet or
TextBox'es? If TextBox'es, where are they... on a worksheet or on a
UserForm? If on a worksheet, which toolbar did you get them from... the
Forms toolbar or the Control Toolbox toolbar?

--
Rick (MVP - Excel)

"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- Hide quoted text -

- Show quoted text -

Dear Rick,

thank you for your swift answer.

what a mishap from my side. Sorry about that. I meant "text box".
There is of course no text field in Excel.

Regards, Andreas