Like this?

Sub update_autoshape()
txt = Range("A1").Value
ActiveSheet.Shapes("autoshapewithassignedname").Se lect
Selection.Characters.Text = txt
End Sub



...but then you have to start the macro yourself after updating cel
A1. If you want it to be updated automatically when pressing enter i
A1 I don't have a clue.

Anyone else?


Erlen

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