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.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.
Link a textbox to specific cell in Excel
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 click the Horizontal Text Box.
Step 2: While text box is selected put your cursor in the formula bar and type in = and then click on the cell you want to link to. See screenshot:
Now it displays the content of linked Cell C6 in the textbox. In addition, when we change the content in linked Cell C6, the content in textbox will update automatically.