No macro needed for that. Select the autoshape. Go to Excel's formula bar
and enter
=A1
--
HTH. Best wishes Harald
Followup to newsgroup only please
"ianripping " skrev i melding
...
At the moment I have an autoshape which I have a asigned a name to.
I want it so that when the text in A1 is updated, the value of A1 is
copied and entered as text into the auto shape.
Any idea's?
---
Message posted from http://www.ExcelForum.com/