How to Link a Text Box to a Cell in Excel?
You can link a text box to a cell to show the content of the selected cell in the text box. By doing this, you dynamically change the text on your sheet, because when the value in the linked cell is changed, the text box will update automatically.
Following are the steps to follow:
Step-1
In the Ribbon, click on the Insert tab, and from the Text, the group chooses Text Box.
Step-2
In the Ribbon, click on the Insert tab, and from the Text, the group chooses Text Box.
Step-3
To link a text box to a cell, first
(1) select the text box and then in the formula bar,
(2) type the equal (=) symbol, and
(3) click on the cell you want to link. When done, press Enter.
As a result, the content of the selected cell is displayed in the text box.