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.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
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.

arrow blue right bubbleLink a textbox to specific cell in Excel

Hot
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 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.


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh