Tom’s Tutorials For Excel: Linking a Drawing Object to a Cell
Here’s how you can link a cell’s value to be displayed inside a drawing object. In this example, a Text Box is being used, but this method will also work for Rectangles and other draw-able Forms shapes.
As you see in the following pictures, draw the shape onto your worksheet, and select it. In the formula bar, enter a formula such as
=A1, or whichever cell whose value you want the shape to show.
Whether the linked cell (A1 in this example) is meant for manual data entry, or it holds a formula, the shape will also show that cell’s contents.