How To: Link Cell Contents to a Text Box in Microsoft Excel
To link text within a cell to a text box, click in the text box, then use the “=” sign in the formula line, navigate to a cell, and hit enter, and the contents of the cell will be tied to the text box.
www.thinkreliability.com