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 i
copied and entered as text into the auto shape.

Any idea's

--
Message posted from http://www.ExcelForum.com