Display cell contents in a text box (shape) and linking
Dear Experts:
below macro grabs the contents of cell B7 and displays it in a text
box (shape, not a control!). How do I have to re-write the code to
have the contents of the cell linked to the contents of the shape.
That is, whenever the cell contents changes, the contents of the text
box is to be updated as well.
Help is much appreciated. Thank you very much in advance. Regards,
Andreas
Sub AddTextBox()
ActiveSheet.Shapes.AddTextBox(msoTextOrientationHo rizontal, 97.5,
28.5, 96.75 _
, 17.25).Select
Selection.Characters.Text = Range("B7")
With Selection.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
End With
|