Link Text Box to a Single Cell or Multiple Cells in MS Excel | Dynamic Textbox Formula in Excel

In this video I demonstrate how to link a text box in Microsoft Excel to one or many cells. Linking to a single cell is quick and easy to achieve. Linking to multiple cells requires a formula that concatenates the cells values into a single text string.

Table of Contents:

00:00 - Introduction
00:34 - How to link a text box to a single cell
01:29 - How to link a text box to multiple cells
------------------------

[hautecommercialrealestate]

Outstanding video - I had no idea this could be done! Your videos are helping many people, Chester, thanks, and please keep making them, you're one of the best out there!

[IvanCortinas_ES]

Excellent tutorial Chester. Another possibility would be to use CHAR(10) (more classic). Thank you!!!

[Ronaldograxa]

at 1:09 when i press enter i get an error " THIS FORMULA IS MISSING A RANGE REFERENCE OR A DEFINED NAME" anyone know why

[YoussefTsun]

How can i make the other way around? To affect what in cells by editing what is in the textbox

[tomlowenstein]

Very useful, thanks. Is there a way to have different text formatting within the text box? So, for example, the first line is bold and font size 12pt, and the second line is regular and 10pt?

[mdmilonmahamud]

How can I do it in google sheets? It’s very need for me.

[stanislasgrare]

Dear chester. how would you do using VBA ? i cannot find any shape.formula property

[davidtopp]

Good Morning Chester,

Hopefully you can help me. I am using a MacBook Pro running Ventura and I am trying to create some links between some cell values and a floating text box on a separate sheet. When I try this by creating the text box and then entering a = sign and then clicking on the cell with the value, nothing shows in the text box except the = sign.

[LotfyKozman]

How did you link between the PT and the other dropdown scenarios?

[ellev]

Is it possible make different color for each cell. Thanks

[Flakes]

And how to doit the other way around? Link the cell to a Text Box.

[markk]

error " THIS FORMULA IS MISSING A RANGE REFERENCE OR A DEFINED NAME"