How to link textbox to a specific cell in Excel?

Do you know how to link textbox to a cell in Excel? By doing this, you can format the cell value with the textbox and change the textbox color, and when the value in the linked cell is changed, the textbox will update automatically. This article will show you the cool trick to link a textbox to a specific cell in Excel quickly.

Link a textbox to specific cell in Excel

Link a textbox to specific cell in Excel

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

In Microsoft Excel we can link a textbox to a specific cell to show the linked cell content in the text box. What's more, if the value of the linked cell is changed, the textbox will update automatically. You can do it with following steps:

Step 1: Click the Text Box button under Insert tab, and insert a textbox in your worksheet.

Step 2: While text box is selected put your cursor in the formula bar, type in = symbol and then click on the cell you want to link to, and finally press the Enter key. See screenshot:

Now the textbox displays the content of linked Cell A3 in the textbox. In addition, when we change the content in linked Cell A3, the content in textbox will update automatically.

Recommended Productivity Tools

Office Tab

Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel