EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF

Link Textbox To Cell

The following steps detail a quick technique to dynamically update the contents of a textbox in Microsoft Excel. First let’s begin with some data.

1. Click insert tab on ribbon

2. Click textbox

3. Click an area on the sheet to insert textbox

4. While the frame of the textbox is selected (circles on edges of textbox must show up) Click inside the formula bar and type “=”

5. Now select the cell you wish to appear in the textbox

6. Now the 50 appearing in cell C5 is linked to the textbox. Any changes to this cell will be reflected in the cell.

This trick can be used when data is constantly being updated. This is an alternative to making redundant updates. I like to use this technique in bar charts when I am running different forecasting scenarios. “Let’s work smarter not harder.”


Footer

Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.