Microsoft Excel has a functionality where we can link a textbox to a specific cell. If we change the data in the cell, the value of the linked cell gets updated automatically. Below are the following steps to link a cell to a text box:

1. Open Excel
2. Click on the Insert tab
3. Click the Text Box button

4. A text Box will Open

5. Select the Text Box
6. Type = in the Formula Bar
7. Select the cell where you want to give a reference

Let us take an example

1. Open Excel
2. Click on the Insert tab
3. Click the Text Box button
4. A text Box will Open
5. Select the Text Box
6. Type = in the Formula Bar
7. Select the cell A1

8. After we select Cell A1, automatically it will display “=$A$1”
9. Now when we change the Text in cell A1, automatically text in the Text Box will change